Network DB gets corrupted

RichO

Registered Yoozer
Local time
Yesterday, 18:54
Joined
Jan 14, 2004
Messages
1,036
We have a network DB at work with 5 machines running Access using SQL Server table storage. Ever since we installed Access on the network there has been an occasional problem with the DB getting corrupted for one reason or another. Often times it was because a user closed out using the [X] instead of the exit command button. This has been remedied by disabling the [X] but still the DB gets corrupted and a message is displayed something to the effect of

"C:\ThisFolder\ThatFolder\YourDataBase.mdb is not a database...blah blah blah... would you like Access to repair the database?"

... and then all users must exit Access so it can be repaired.

Lately this has been happening more often than before and I have been doing alot of edits and additions to the DB.

What type of things would I look for that may cause this to continually happen?

Thanks for any help.
 
First try to create a new database, then import all objects from the original one, compile new db and repair/compact.
This might help.
 

Users who are viewing this thread

Back
Top Bottom