Multiuser problem 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...

[JHausmann]

What does your connection look like?

[ttingen]

JHausmann,

This is what it looks like. sPath is obtained from an ini file.

Set connProgram = New ADODB.Connection
    
connProgram.Mode = adModeShareDenyNone
connProgram.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                 "Data Source=" & sPath & _
                 ";Jet OLEDB:Database Password=pwd;"