Is MS ACCESS a multi user database

[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.

 

[Douglas J. Steele]

Yes, you should be able to. Why? Are you having a problem?

 

[Guest]

One other question, what does the "--" after SUMPRODUCT
for?

Thanks

 

[Douglas J. Steele]

I have no idea what you're talking about.

 

[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

 

[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.