One database - multiple users?

[Guest]

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.

 

[Lynn Trapp]

Access is designed for multiple user by default. Yes, users can edit data at
the same time and, unless, they happen to be trying to edit the same records
they should not have any problems at all.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[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

 

[Joseph Meehan]

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.

Access handles the problems. I is best to split the database (one
database on the server to warehouse the data and other databases on the
user's machines for all the forms, reports queries etc, linked to the
table(s) in the database on the server.

Access "locks" records or groups of records so if two people are looking
at the same group and one makes a change, it warns the second user who wants
to make a change that there was a change made since they opened that record.