MS Access multi-user environment

[ttingen]

Does anyone out there know the specifics on setting up an Access database for a multi-user environment?

MSDN doesn't go into the specifics of setting it up.

The database resides on a file server and < 10 people will access it simultaneously.

[parksie]

Once you've set the record locking, nothing more needs to be done. Just access (heh) the DB as normal.

[ttingen]

Parksie,

I laughed at the little pun.

Please explain how to set up the record locking. I read through the info on MSDN and it mentioned a lock file that would reside with the db but didn't go into specifics about setting it up.

Thanks.

[parksie]

The lock file is automatically generated by Access.

Try Tools->Options|Advanced.

[ttingen]

So just setting up the users in the database should set them up in the lock file when it is generated by Access right?

So when setting up the users in the Tools->Security->User and Group Accounts should I enter their computer name as the Personal ID or what. How do I set up the users in the database?

Thanks for your help Parksie. I've posted a similar question previously and didn't get any help.

[monte96]

If you planning on more than 10 concurrent users, you should consider using SQL Server instead. Access doesn't really scale well beyond about 10 users..

Yep that is right what ttingen is saying. All can be done in Access 97 / 2000.

Hope that helps