How can one tell if a database has been opened or not?

[llyal]

How can one tell if a database has been opened or not?

How can one tell if a database has been opened or not; i am creating a compact utility and need to know if a database is open or not;

Any help?

Thank you!
Llyal Gordon

 

[Neal]

Generally, you can look in the folder where the db is located. If there is a file with the same name but has the extension .ldb, it means someone has it open.
There is a great utility called Modeuser.mdb that is on Candace Tripp's website. It will tell you who has it open and in what mode. Her site is http://www.candace-tripp.com/