How can I check if an Access database is open?

  • Thread starter Thread starter Mike L
  • Start date Start date
M

Mike L

I need to determine from one Access database whether another Access database
is open. How can I do this?
 
Mike L said:
I need to determine from one Access database whether another Access
database is open. How can I do this?
Click to expand...

Look for the presence of a xxx.ldb file in the same folder as the database
file, where xxx is the same name as the database. If .ldb file is present,
the database is open. Use the Dir function.
 
Thanks, Stuart. But if the target .mdb is terminated abnormally, the .ldb
may still exist. Is there another way, perhaps using the windows api?

I thought of having the target mdb write the system date/time to an internal
table every minute; link to this table and check if no update has occurred
within the past minute, which would indicate that the target mdb is not
executing. Hoping there is an easier way.
 
Mike L said:
Thanks, Stuart. But if the target .mdb is terminated abnormally, the .ldb
may still exist. Is there another way, perhaps using the windows api?

I thought of having the target mdb write the system date/time to an
internal table every minute; link to this table and check if no update has
occurred within the past minute, which would indicate that the target mdb
is not executing. Hoping there is an easier way.
Click to expand...
<snip>

Ok. Try this:

Public Function dbOpen(dbFile As String) As Boolean
Dim fh As Integer

fh = FreeFile
On Error Resume Next
Open dbFile For Binary Access Read Write Shared As fh
dbOpen = (Err.Number > 0)
Close fh
End Function

If dbFile is open, it will be locked by the OS and the Open command will
fail.
 
Mike said:
I need to determine from one Access database whether another Access database
is open. How can I do this?
Click to expand...


I think you can just try to use OpenDatabase with the
Exclusive Option.
 
Back
Top