Force all users to disconnect from 2010 Access backend database

by

Users put “locks” into an LDB. An LDB is a kind of database of locks for MS Access.

Users also put “locks” onto LDB’s and MDB’s. These locks are part of the native database primitives provided by Windows and Windows networking.

If there are no locks IN the ldb, the user is not writing into the MDB.

If there are no locks ON the mdb, the user is not using that Windows/Networking service.

To get exclusive locking on an MDB, you need both. MSAccess won’t let you exclusive lock while the LDB has entries showing someone else is using the database, and Windows won’t give you an exclusive lock while it has locks showing someone else is using the database.

To 100% bulletproof empty the LDB, you delete the LDB. That is why Access always attempts to delete the LDB on close. If Access crashes, or the network is disconnected, or the PC or Server is turned off, the LDB will have data (“locks”) that have not been deleted. You get rid of them by deleting the LDB.

Access won’t be able to delete the LDB if a user still has Windows/Network locks on the LDB. Since Access is ignoring existing “lock” entries to clear broken “lock” entries, this is how Access/Windows prevents Access deleting the LDB while another user is still using it.

If EITHER the Windows locks or the Access/LDB “locks” exist, you can’t get exclusive ownership. If ONLY the Access/LDB “locks” exist, you can delete the LDB, and then get exclusive ownership.

If ANY Windows/Network locks exist, nothing you do with Access can allow you to disconnect another person from the network. You need to go to the Server/PC that hosts the file, and force the disconnection. Access is not a network administration program that does this for you.

Last I looked, Windows Server was set by default to time-out broken file connections 15 minutes after the network session was lost. So if you turn off a PC, wait 15 minutes, then the Windows/Network locks will go (default timing). Alternatively: Admin tools, Computer Management,System Tools,Shared Folders, Sessions. Select the file you wish to unlock, and delete the session.

More Related Contents:

  1. Combine values from related rows into a single concatenated string value
  2. Bang Notation and Dot Notation in VBA and MS-Access
  3. “General error Unable to open registry key Temporary (volatile) …” from Access ODBC
  4. Is there a simple way of populating dropdown in this Access Database schema?
  5. How can I get table names from an MS Access Database?
  6. Is there any way to create multiple insert statements in a ms-access query?
  7. Running Microsoft Access as a Scheduled Task
  8. How to diagnose MS access crashes
  9. “Operation must use an updateable query” error in MS Access
  10. VBScript & Access MDB – 800A0E7A – “Provider cannot be found. It may not be properly installed”
  11. Run-time error ‘3061’. Too few parameters. Expected 1. (Access 2007)
  12. MS Access trigger?
  13. MS Access LIMIT X, Y
  14. Is MS Access (JET) suitable for multiuser access?
  15. Save password for ODBC connection to MS SQL server from MS Access 2007
  16. ConcatRelated() in Access, using two keys
  17. Concatenating multiple rows into single line in MS Access [duplicate]
  18. How to write Case Sensitive Query for MS Access?
  19. ConcatRelated function in a query
  20. Access 2007 – INSERT and instant SELECT doesn’t retrieve the inserted data
  21. UrlDownloadToFile in Access 2010 – Sub or Function not Defined
  22. Null values for variables in VBA
  23. Custom row source for combo box in continuous form in Access
  24. MS Access query returning Chinese characters – possible table corruption?
  25. Using a centralized VBA module in multiple Access databases
  26. How to execute a query in ms-access in VBA code?
  27. How to add a menu item to the default right click context menu
  28. VBA – Run Time Error 3271 using DAO object
  29. Working with multiple programmers on MS Access
  30. Trouble with InputBoxes

Leave a Comment