So I have a web database in Access 2010, Sharepoint 2010, as an accdb file.
I have a backup of the database, but the backup doesn't have the data in the tables.
For some unknown reason, the database was corrupted. I tried "Compact & Repair DB" which made the situation 10x worse.
Now the MsysAO table is missing over 100 rows. Before, the rows were there but full of non-typical random ASCII char's like you see in a corrupt file.
Now, when on the sharepoint site, all of my DB objects are missing except for a select random few.
I tried to resync the DB to overwrite the sharepoint site, except it is overwriting the DB instead, and deleting every object so it matches the SP site. So then I tried to open and save every single object to give it a new recently modified date, then resync. This didnt work either.
I tried to save a backup of the database as a local unpublished database, but all of the tables link back to their original locations, which cannot be found.
I've been developing this DB over a year now, and I'm not sure how to restore it and get the data back. The site went from over 150 objects to about 8, and all of the data is not visible (i'm hoping it wasnt deleted when the MsysAO table was corrupted).
Any Ideas?