Multiple access at the same time?

[Kaylen]

If I am going to save my database on a shared drive, is it possible to have
more than 1 user in the database doing data entry at the same time?

 

[Douglas J. Steele]

Access is multi-user capable right out of the box, but it's best if your
application is split into a front-end (containing the queries, forms,
reports, macros and modules), linked to a back-end (containing the tables
and relations). Only the back-end should be on the server. Each user should
have his/her own copy of the front-end, ideally on his/her hard drive.

For more details, see what Tony Toews has at
http://www.granite.ab.ca/access/splitapp/index.htm or what Albert Kallal has
at http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

 

[Tom Wickerath]

Hi Kaylen,

Here is another article that you may find useful:

Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/articles/multiuser.htm

As Doug stated, you should split your application into two files: a FE
("front-end") and BE ("back-end"). Each user should have their own copy of
the FE, run from their local hard drive (ie. no two users ever sharing the
same copy of the FE "application" file). Access MVP Tony Toews has a neat
utility available, "Auto FE Updater", which takes the pain out of having to
distribute updated copies of the FE to each user, each time you make a
change. This is discussed in the above article.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Bob Larson]

And I have a tool to enable auto updating for any frontend as well (just as
an alternate):
http://www.btabdevelopment.com/main/MyFreeAccessTools/tabid/78/Default.aspx

--

Thanks,

Bob Larson
Access MVP

Free Access Tutorials and Resources: http://www.btabdevelopment.com