Unrecognized file format

[nashat21]

Hi! We have been having issues recently where our Access database, when being used by multiple users, and when one user exits and relaods the database gets the error, "unrecongized database format" and asks to repair the database. We feel that this may be the cause of multiple users tyring to access/change a record at the same time. Could this be the case, or could it be anything else? How can we prevent this from happening again? It happens fairly randomly, however, when it does occur, it tends to happen often for a few days and then subsides until it decides to have a fit again!

Any feedback would be greatly appreciated!

Thanks

 

[BLeslie88]

Have you....

You can set record locks in Tools\Options\Advanced\Default Record Locking and change this to Edited Records.. Should stop users from making changes at same time....
Hope this helps....

Regards,
Brian K Leslie

 

[DBL]

If you are using the database in a multi-user environment you should split your database in to backend and frontend. There is a database splitter wizard under Tools> Database Utilities. From the problem that you are getting, my guess is it isn't split at the moment. Once it's split, put the backend on the server and then you can give each user their own frontend on their hard drive (my preferred option) or you can have everyone accessing the same frontend on the server.

As Brian suggests, make sure your record locking level is set to Edited Records and you can also set Default Open Mode to Shared in the same location.

If you want to find out a bit more about splitting the database, search the forum for Splitting, Backend, Frontend for a wealth of stuff.

If there are multiple users for the database, it's really the only way to go.