-
MSAccess Holding Locks
My users have a front end in MS Access 97. It simply
opens a linked table to SQL Server 7 and puts a form up
for editing. This causes a page lock which blocks
other processes from updating the data they are locking.
I know they need to rewrite the applicaiton. But in the
mean time is there anything i can do on the SQL Server 7
end to force them drop the locks after they initally open
the table on the MSAccess end. Or even better, not let them
lock at all or force a row level?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|