sankar said:
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
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
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm