Issue
Users receive a "Write Access Denied" error when opening a SQL database.
Discussion
When a database is opened, the product writes an entry to the "Locking" table and immediately deletes it to verify that the user can write to the database. If the program crashes or the connection to the database drops before that entry can be deleted, the entry gets 'stuck' in the table. When the program attempts to write that record again, it cannot because the record is already there - the program interprets this as the database being in "READ ONLY" mode because the 'write' failed.
Resolution
Only an SQL Administrator can perform these steps.
- Have all users close the database/program
- Open the database in SQL Management Studio
- Locate and Edit the "Locking" table
- Delete any entries in the table and close the table
Have the user reopen the database (or program).
Related Articles