Unable to open dB exclusively

[dan2bhm via AccessMonster.com]

Occasionally, I have experienced times when I am unable to open a database
exclusively. I understand that if someone has it open, its not possible to
open it exclusively. However, I have a tracking mechanism in the database
that checks to see who has the database open.

Has anyone ever experienced times when you are unable to exclusively open the
database to make some updates / modifications?

Its almost like the dB was busy doing something and it locked up doing some
sort of procedure.

Any ideas????

 

[Guest]

This may not be the complete answer, but there two time I have ever seen this
personally. One is if someone crashed the database and the ldb file was not
deleted. See if there is an ldb file that has the same name as your mdb (do
this with your database closed). Try to delete it. That may cure the
problem.

The other is if someone else has opened the mdb exclusively by openin Access
directly, clicking on open, selecting a database, then selecting open
exclusive. It will not create an ldb file in this case.

 

[dan2bhm via AccessMonster.com]

Thanks, its definately possible that someone crashed the dB and the file is
still locked on it. However, the database is working fine, its just hung up
somewhere. I can't delete the ldb file because it's still "locked".

If it's open exclusively by one user, noone would be able to open the
database. In this case, everyone can open the database fine. I just can't
open it exclusively.

Any other ideas?

This may not be the complete answer, but there two time I have ever seen this
personally. One is if someone crashed the database and the ldb file was not
deleted. See if there is an ldb file that has the same name as your mdb (do
this with your database closed). Try to delete it. That may cure the
problem.

The other is if someone else has opened the mdb exclusively by openin Access
directly, clicking on open, selecting a database, then selecting open
exclusive. It will not create an ldb file in this case.

Occasionally, I have experienced times when I am unable to open a database
exclusively. I understand that if someone has it open, its not possible to

[quoted text clipped - 8 lines]

Any ideas????

 

[Guest]

If the database is working as it should except you can't open it exclusively,
then it is not a problem with the ldb.

What method are you using to open it exclusively? What message are you
getting?

Thanks, its definately possible that someone crashed the dB and the file is
still locked on it. However, the database is working fine, its just hung up
somewhere. I can't delete the ldb file because it's still "locked".

If it's open exclusively by one user, noone would be able to open the
database. In this case, everyone can open the database fine. I just can't
open it exclusively.

Any other ideas?

This may not be the complete answer, but there two time I have ever seen this
personally. One is if someone crashed the database and the ldb file was not
deleted. See if there is an ldb file that has the same name as your mdb (do
this with your database closed). Try to delete it. That may cure the
problem.

The other is if someone else has opened the mdb exclusively by openin Access
directly, clicking on open, selecting a database, then selecting open
exclusive. It will not create an ldb file in this case.

Occasionally, I have experienced times when I am unable to open a database
exclusively. I understand that if someone has it open, its not possible to

[quoted text clipped - 8 lines]

Any ideas????

 

[Guest]

Dan

The LDB can appear to be fine and still be hung.

Open the LDB in NotePad and see who is in it. Call each one to verify that
they are not in the database. If all are out, the ldb is hung and needs to be
forced closed or the machine it is on needs to be rebooted. Those are the
only 2 ways to free up the ldb so it can be deleted.

Once again your post demonstrates the hazard of a shared database that is
not split.
--
Bill Mosca, Microsoft Access MVP

Thanks, its definately possible that someone crashed the dB and the file is
still locked on it. However, the database is working fine, its just hung up
somewhere. I can't delete the ldb file because it's still "locked".

If it's open exclusively by one user, noone would be able to open the
database. In this case, everyone can open the database fine. I just can't
open it exclusively.

Any other ideas?

This may not be the complete answer, but there two time I have ever seen this
personally. One is if someone crashed the database and the ldb file was not
deleted. See if there is an ldb file that has the same name as your mdb (do
this with your database closed). Try to delete it. That may cure the
problem.

The other is if someone else has opened the mdb exclusively by openin Access
directly, clicking on open, selecting a database, then selecting open
exclusive. It will not create an ldb file in this case.

Occasionally, I have experienced times when I am unable to open a database
exclusively. I understand that if someone has it open, its not possible to

[quoted text clipped - 8 lines]

Any ideas????