Is MS ACCESS a multi user database

K

Kiran Kumar

Is Access a multi user database.
i.e. can I connect from more than one computer to a single
MS Access database at the same time through ODBC.

Pls help me in this matter.
 
S

StCyrM

Good afternoon

You can have up to 255 concurrent users. What kind of help do you need?

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
Ottawa, Ontario
 
D

Douglas J. Steele

Yes, Access is multi-user out of the box.

All of the users must have at least Change access to the folder where the
MDB file exists. (This is Read, Write, Delete and eXecute access). This is
because the first person to open the database causes a locking file (.LDB)
to be written to the same folder where the .MDB file is located. Subsequent
users update that locking file, and the last person to close the database
causes the .LDB file to be deleted.
 
Top