Cannot open multiple ADP sessions

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

I have an Access Project on a SQL Db which works great. The problem I have
is that if one user open the ADP file, the file gets locked and other users
get a "read only" message when they open the file. I have tried to look at
the folder properties to make sure it is shared and it is.

Other things I noticed is that usually with MDB and ADP files, when a user
opens the file, the system creates the .ldb file. THIS IS NOT HAPPENING.
When the first user opens the ADP file, the lock file is not being created.
I think that this is interfering with teh system's ability to open multiple
sessions.

Does anyone know why this is happening? We have had to put a copy of the
ADP file on each workstation in order to use the program, and this works,
however, making modifications to the ADP or creating new releases in a pain
because we have to release it on each individual workstation.

Any ideas?

-Stephen
 
S> I have an Access Project on a SQL Db which works
S> great. The problem I have is that if one user
S> open the ADP file, the file gets locked and other
S> users get a "read only" message when they open the
S> file. I have tried to look at the folder
S> properties to make sure it is shared and it is.

Each user indeed has to have an individual ADP file. Access resaves it
reflecting some user settings. It shouldn't be hard to create a logon script
for users to update the file.

As for ldb, it's only for MDB, not for ADP's.

Vadim
 
Back
Top