I have a phantom record which is refusing to budge. The Clean Phatom Records command in Database Tools shift it. I had a problem like this once before and I compacted the database. However whenever I try to do this now I am getting the following Error message:
SQLITE Error 1 - cannot VACUUM - SQL statements in progress.
I have tried to export to a gedcom and import as a new file but still getting the same message.
Please help me solve this frustrating conundrum...