| |
| |
OST/QB - Error Message: Write Access Denied
| Views: 1120 Last Updated: 02/13/2023 01:13 pm |
0 Rating/ Voters
|
 |
| Be sure to rate this article 5 Stars if you find it helpful! |
Symptom
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 the SQL Administrator can perform these steps.
- Open the database in SQL Management Studio
- Edit the "Locking" table
- Delete any entries in the table and close the table
Have the user reopen the database (or program).
|
| |
