I have a be database living on a network drive with 10-20 users on front ends at any one time. Lately we have been getting a lot of weird errors.
After some research it seems one table in particular on the be is corrupted. I've tried "Compact and Repair", it just freezes. Tried selecting/deleting the records which read "#Error" and I get a "Not a Valid Bookmark" error, hit ok, "Not a valid bookmark. This cycle repeats 10 to 12 times then stops.
At the moment I can't export the data. Access freezes.
The "#ERROR" field has taken over maybe 3-5% of the database.
How can I salvage as much of my data as possible and prevent this from happening again?
Is there something I can use in SQL or VBA to delete the corrupt records?