Database Repair Tool/Software?

[PATRICKPBME]

I have recently been getting an error that reads "Not A Valid Bookmark" when doing a search. I have read the "help" explanation for this and it basically seems to say there is something messed up with the database. I have tried the "Compact and Repair" option without any success. Wondering if anyone has any advice or if anyone is aware of a good software repair program.

[aytee111]

Try creating a new database and importing all the objects.

[isladogs]

Try creating a new database and importing all the objects.

Yes but that should only be done as your final resort.
If you have a large db, it can take a very long time and things can go wrong
Make a backup first

Before you do that try decompiling the database - this will remove any corrupt compile code
Once again make sure you backup the db first
For more info - see here: http://www.fmsinc.com/MicrosoftAcces...Convention.asp

Afterwards, recompile & compact again

If the problem still exists, you can also try repairing any errors that may exist in the hidden, system MSysObjects table.

For more info, see this link:https://www.access-programmers.co.uk...d.php?t=293579
And, of course, make a backup first