Can't break exclusive access

[Leif]

My understanding of Access locking is that the first user
to connect Access is given exclusive access (if they have
that permission). Once other users attempt to connect the
exclusive lock is changed to a shared lock.

The problem I have is that when the system admin. person
logs in first, other users may not log in. In other
words, the exclusive lock is not be changed to a shared
lock. The message the second user sees is "The database
has been placed in a state by user 'username' on
machine 'machinename' that prevents it from being opened
or locked." where username and machine will be specific
to the system admin. person.

The system admin. person is not doing any activity that
would require the exclusive lock to be maintained (such as
a compress/repair, or design work).

Does anyone know the reason this happens and how it can be
solved? Thanks.

Regards,
Leif

 

[J. Clay]

..adp applications should be copied to each users machine so that each user
has their own copy. You should not use a common instance of an adp off of a
server.

HTH,
J. Clay