Database Corruption in Access

[Sameer Gokhale]

Hi everybody, I just wanted to ask if anyone has seen a
problem with access databases that causes corruption of a
database when users exit the database. The users who are
logged in are fine however the one that exit cannot get
back in. We are running windows 2000 SBS. We can't seem
to find out why this is happening. Thanks Sameer.

 

[Albert D. Kallal]

The corruption is not occur when they exit. However, the corruption likely
only noticed when the database is being opened!

You should be running a split database when doing ANY kind of muti-user
application. Further, each users front end should be a mde.

For info on splitting, check out:
http://www.granite.ab.ca/access/splitapp.htm

http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba15_3.htm

For info on why / preventing corruption, check out:

http://www.granite.ab.ca/access/corruptmdbs.htm