I have a VBA procedure which updates several back-end Access databases and then compacts them remotely; however this will only work if I have exclusive access to each of the back-end databases, and since they are used quite heavily it's hard to find time in the working day when this is the case. I can use Dir(path/database.ldb) to find out whether the file is locked and in use, and wait until that ldb file disappears before compacting, but is there any way to interrogate the ldb file from within VBA to list which machines/users are logged into the back-end database in order to contact them to co-ordinate compacting. I know the .ldb file is essentially a text file, but is it available to interrogate with VB using the Access Object model?
Laters, Z
"42??? We're going to get lynched!
Laters, Z
"42??? We're going to get lynched!