How do you determine if a linked database is open?

[N2Life]

Database A contains a link to a table in Database B. This link is, of course, valid even if Database B is closed. Is there a way in VBA code within Database A to check if Database B is indeed open? I am using Windows XP, Access 2000.

Something like:
Function LinkedDatabaseIsOpen("DatabaseB.mdb") As Boolean
... some code [ which is what I am asking for ]
LinkedDatabaseIsOpen = True ' Or maybe False
End Function

My thanks in advance to the helpful experts in these forums.
N2Life

 

[PWise]

Check for the lock file

LinkedDatabaseIsOpen = dir("DatabaseB.ldb")>""

 

[N2Life]

Very clever! And the simplest approach is always the best. Thank you.