Reputation: 105
unrecognized database format access 2007 split database
I have an MS Access 2007 split database. The Back End database contains 1 table. It is on a shared drive and front end has a data entry form with Macros, also a linked table from back end. Everyone in the organization has same version of Access (2007), same operating system etc.
Problem is I am able to open and add records to the front end but when anyone else try to open the front end it comes up with "Unrecognized database format" and they couldn't open it.
So far tried changing New database sort order to general - Legacy/ Compact and repair database from database tools but still not working for other users. Almost spent half a day searching and trying various solutions without success. Any help into right direction will be highly appreciated.
Upvotes: 0
Views: 309
Answers (1)
Reputation: 2052
The lock file got corrupted. Delete it and re-open the application.
Upvotes: 1
Related Questions
- Splitting Access Databases
- Splitting Database does not bring over form (only table)
- Microsoft Access, Splitting Error
- Unrecognized Database Format While trying to open access 97 database
- Fetch Data Into Split Database?
- Migrating Table Macros to VBA with a now split Database
- Unrecognized database format to other PC
- Access Database format not recognized by ASP
- Unrecognised database format
- Query after splitting access database