Multiuser problems with MS Access

[ttingen]

I'm new to the multi-user arena in MS Access(done mainly desktop apps in the past).

The front end is VB6 accessing the database via ADO 2.1. The database is on a Netware server.

The option is selected to open the db in shared mode. The db is password protected. There is a lock file in the database directory and it has an entry for the Admin user.

From what I've read on MSDN there has to be workgroups or user groups set up or something like that but it doesn't go through the process of setting them up. What happens now is one user will be in the app and another will try to open it from their workstation. The one trying to open it gets an error stating that the file is already in use.

If anyone could help with the user group set up and how that works as well as the lock file information I would be appreciative.

Thanks...

[ande211]

I had the same problem with some of my Access databases. What I did was go into the database and under tools go to security and under that go to User and Group permissions... and for object type change it to database. Then under permission uncheck where it says Open Exclusive that should allow multiple users on the database.

Hope that helps.

[ttingen]

So how do I set up users for the database. Do I enter their user name and id in the users and groups permission dialog or do I enter the information into the lock file on the server.

And when setting up the users their id, is the id their computer name? It just appears that way because in the lock file which contains the id and Admin user right now the id is the computer name.

Thanks...