I had to do this once upon a time and it wasn’t pretty. I think i made a copy of the data file in another directory, then went to home base and client maintenance and deleted all of them. This should result in an empty home base.

Then copy all files back to the correct folder and run database maintenance. Keep your fingers crossed