Table of Contents

In On-Screen Takeoff, Quick Bid, and Digital Production Control Users Receive an Error Message: Write Access Denied - OST QB DPC

Views: 717 Last Updated: 08/22/2024 12:04 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.

On-Screen Takeoff error message that write access is denied

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

Note

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).