Access temporary locking file

stepanmasek
New Member

Posts: 2

Access temporary locking file Mar 13, 2016 7:00:17 GMT -5 eustacetodd likes this

Quote

Post by stepanmasek on Mar 13, 2016 7:00:17 GMT -5

The temporary locking file (.laccdb in Access 2007 and .ldb in all prior versions) that is created when a user is "in" an Access database, contains info on sharing the database.

I'm wondering if it is possible to read this temporary file if it contains perhaps, the user or machines names (or any useful info) that are currently in the database. My goal is to find out what machines/users are currently "in" my database and display this on my application dashboard.

I know that I could code all of this into a table, etc. etc. but am hoping this file might already contain that data. Any ideas?

drcard
Software Review Panel

Posts: 581

Access temporary locking file Mar 13, 2016 20:22:41 GMT -5

Quote

Post by drcard on Mar 13, 2016 20:22:41 GMT -5

Hi stepanmasek,

The Access temp locking file does provide a list of users/machine currently accessing the data base. The file is designed to be read by any plain text reader, but Notepad doesn't work well and shows some strange characters...Open the file in Word and it will be better to view and read.

This file deletes its contents when all users have disconnected from the data base. If a copy of the current list of users and machines connected is desired then save a copy under a different name as a doc file.

HTH, Dana:)) 👨‍🔬

eustacetodd
New Member

Posts: 2

Access temporary locking file Mar 22, 2016 7:17:34 GMT -5 stepanmasek likes this

Quote

Post by eustacetodd on Mar 22, 2016 7:17:34 GMT -5

Microsoft have an interesting set of Jet utilities at support.microsoft.com/kb/176670. I don't know if the LDBView utility included in this would be compatible with Microsoft Access 2007 lock files, but you never know! www.oemailrecovery.com/access_recovery.html

eustacetodd New Member Posts: 2	Access temporary locking file Mar 22, 2016 7:19:53 GMT -5 stepanmasek likes this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by eustacetodd on Mar 22, 2016 7:19:53 GMT -5 Check out this also... social.msdn.microsoft.com/Forums/en-US/cbd21feb-77d3-4467-9b00-234a77e1ef3a/how-to-moverecover-data-in-microsoft-exchange-2007?forum=outlookdev

stepanmasek New Member Posts: 2	Access temporary locking file Mar 23, 2016 11:44:56 GMT -5 Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by stepanmasek on Mar 23, 2016 11:44:56 GMT -5 You've been very kind in your efforts to help. Thanks for that. Solved!

Post by stepanmasek on Mar 13, 2016 7:00:17 GMT -5

Post by drcard on Mar 13, 2016 20:22:41 GMT -5

Post by eustacetodd on Mar 22, 2016 7:17:34 GMT -5

Post by eustacetodd on Mar 22, 2016 7:19:53 GMT -5

Post by stepanmasek on Mar 23, 2016 11:44:56 GMT -5