Database is opened exclusively error

B

Brandon

Hello, I have an MDE File for use on the network that is
shared between users. I have it set so multiple people
can log in (default open mode is set to 'shared'). So why
do I get an error message that says, "You attempted to
open a database that is already opened exclusively by
user 'Admin' on machine 'xxx-EVANSR0. Try again when the
database is available."
This is an mde file, so how can he even open it
exclusively? I'm sure he doesn't even know this has
happened either as he knows nothing about MS ACCESS. Can
you help? Thanks!
Brandon
 
B

Brandon

-----Original Message-----


First fine out if he is open exclusively. I never thought of it so I
have never checked but you have a point, why would a mde need exclusive?
Maybe you can open one that way however.

However you may be able to resolve the problem by checking to see if
there is a YOURFILENAME.ldb file in the same directory as the
YOURFILENAME.mde file when not one has it open. If so delete the ldb file.
Click to expand...
This is not the case. I made sure that the user still had
it opened on his desktop and I could not delete the ldb
file.
If you have not split the database so each users has their own front
end, you should do so. Not doing to causes a number of problems, including
the one your describe.
Click to expand...
I have already split the database but I want to know why
this exclusive problem occurs. I know the best way is to
make each user have their own copy of the mde, but I don't
want to complicate it yet if I don't have to. Is there
any specific reason why this problem occurs that I can
mitigate by a setting or some option? Thanks for your
reply I appreciate it!
Brandon
 
K

KMac

Brandon, I am having a similar issue and wanted to know some more specifics
about your situation...
My application is in Access 2002, but my data is stored on a Server that was
recently updated to Windows Server 2003. I am still using the DAO object
model.
Do you see any similarities?
 
Top