Importing LDB (Access Lock File) Into Excel
 

I want to be able to query the Access lock file (*.ldb) from Excel s
that it can give me a snapshot of who is using our shared database.

I attempted to import the *.ldb file as a text file, but I received a
error that says it can't be imported, although I can view the fil
through notepad.

Any suggestions for a quick VBA code to accomplish this?

I've tried renaming the file (from *.ldb to *.txt), but it appears tha
FileSystemObject.CopyFile doesn't allow me to do this. I also trie
OldName and NewName (under the Name command) and that didn't wor
either.

Thanks

--
Message posted from http://www.ExcelForum.com