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?