Who is locking my Access 2007 Database? RRS feed

  • Question

  • I am using Access to share data my building.  We have people developing reports in Excel and Access using the data stored in these Access files.  I have another set of Access fles that actively update the data files.   Occasionally a user links to one of the data files and locks it, preventing the update from happening (I over write the file with a new one from a quarantied area with no links).  I cannot figureout how to find who the user is that is locking an Access 2007 database.  Before 2007 I could get the computer responsible from the ldb file.  But the laccdb does not want to give up its secrets.  PLEASE!! I need to figure out how to identify the users doing the locking.


    Bill Benton (Am I even in the right forum?  This place is really confusing.)

    Tuesday, August 30, 2011 2:28 PM