My client has an Access 2007 (accdb) file. It's stored on SharePoint, and there are three users that check it out, make updates, and check it back in. One user is on Windows 7, another on Vista, the third on either Vista or XP (my client wasn't sure).
There are no linked tables, and its only ever used by one user at a time.
I'm told the user on 7 spent several hours adding data, then published to SharePoint. Now, any use that attempts to read the data gets hit with the "Unrecognized database format" error. They sent me a copy, and I get the same thing. It's one particular table (the most important, of course) that does this when trying to open; all the other objects (queries, forms, etc.) open fine, except for those that rely on the table.
Attempting to compact and repair gives the error "The Microsoft Office Access database engine could not find the object 'tbl_TableName'. Make sure the object exists and that you sepll its name and the path name correctly." I also tried to import into a new accdb file, and got the same "Unrecognized database format error."
I suspect it's completely corrupted, but my client is frantic. If there're are no fixes for this, what about these Access recovery programs I saw while Googling this? Do they work? Have a recommendation?