Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tough one; determine if an Access file is open
If the MS Access file you are trying to test is *.mdb/*mde (not *adp/*.ade),
then, you can simply check if there is a [databasefilename].ldb file exists in the same folder as the *.mdb file. Note, here is a small catch: if the *.mdb was previously opened and did not get properly closed (for example, the computer crashed), then the *.ldb may be left there. "XP" wrote in message ... I am using Office 2003 on Windows XP. I need a VBA function to determine FROM EXCEL if a specific MS-Access file is currently open. Can someone please post example code that would determine this; ideally a function that would return true or false. Thanks much in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determine if an excel file is already open | Excel Programming | |||
Tough Excel/Access/VBA Problem! Please Help!!! | Excel Programming | |||
Tough Excel/Access/Windows Problem, need Help!!! | Excel Programming | |||
tough question--determine smallest time from range with exceptions | Excel Programming |