"Unrecognized database format" error

[PaulA]

I have a split 2003 (.mdb) database accessed via 2007. Our users suddenly started getting a ""Unrecognized database format" error apparently for the backend database only. I tried to open it in 2010 and I get the same thing.

I have made no changes that would bring this about.

Any ideas of what is going on? This houses our data (although we can get an archive file if needed).

Thanks!

 

[pr2-eugin]

Did you try a
(a) 'Compact & Repair' on both front and back ends?
(b) Relinking the Back end?

 

[Pat Hartman]

In addition to Paul's suggestions.
1. Try to open the database in a different version of Access. sometimes different versions are sensitive to different problems.
2. Try creating a new empty database and importing all the tables.
3. Try creating a new empty database and linking to all the tables. Try to open the tables. See if you can identify which table has a bad record and which record it is. If you can identify the bad record, you can use append queries to copy all the rows before it and then after it to a new table.
4. Try the /decompile switch. It cleans up p-code but it might fix this also.

 

[jackadision]

This is because there is currently no 64bit version of the Access driver, only a 32bit version . You could try to run the .exe as a 32 bit (Wow64 application) process on the 64 bit machine:

1. Right click your project and select Properties.

2. Select Build and select x86 in the Platform Target dropdown.

3. Save, Rebuild and run you project, you should now get the rows for the table.



You can also visit: accessrepairnrecovery.com/blog/how-to-repair-ms-access-error-3343-unrecognized-database-format-in-ms-access