One database - multiple users?

J

Javanutz

Hi,
Can someone point me to some info as to how Access handles multiple users
opening the same database? Can they make edits to the database at the same
time? I can't seem to find any relevant online resources to this question.
Thanks.
 
D

Douglas J Steele

Access is enabled for multiple users out of the box.

Be aware, though, that the recommended approach is to split the database in
two: a front-end containing the queries, forms, reports, macros and modules,
linked to a back-end containing the tables.

Each user should have a copy of the front-end on his/her hard drive. Only
the back-end should exist on the server.

For more details, see what Tony Toews has at
http://www.granite.ab.ca/access/splitapp/index.htm
 
Top