Dennis,
With Access if the database is open there is an ldb file of the same name as
the mdb file. The first connection creates this ldb file.
You could look to see if there is an ldb file present.
If there is no ldb then there is no connection.
The ldb is not always deleted when the connection is removed so you would
need to try and delete the ldb file. If there is still a connection, the ldb
file is locked and you will not be able to delete it.
If you can not delete it there is still a connection.
Doug
"Dennis" <De****@discussions.microsoft.com> wrote in message
news:FB**********************************@microsof t.com...
If I have one computer open a connection to an access database that's on a
network Drive, how can I determine from another computer if there is a
connection to that database open on the other computer? Would appreciate
any help.
--
Dennis in Houston