database corrupted

message from sankar on 23 May 2004
i have database in lan. more than one user can have access with their
own objects. hence same objects can not be allowed to update the same
time.but sometimes it gets corrupted.let me know the reason for that.
is it possibility to support the multiuser environment.please reply
soon
 
Tony Toews replied to sankar on 24 May 2004
Is your MDB split? If not you want to split the MDB into a front end
containing the queries, forms, reports, macros and modules with just
the tables and relationships. The FE is copied to each network users
computer. The FE MDB is linked to the tables in the back end MDB
which resides on a server. You make updates to the FE MDB and
distribute them to the users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. It also supports Terminal Server/Citrix quite nicely.

If it is already split then see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Tony
 

Archived message: database corrupted (MS Access Database)