Web Development

Ask something
Discussion Locked

Record Locking Access97 Front End to SQL

0 helpful
5 replies

by cking

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
What is the default recordlocking method used by Access97? Using Access97 as a front end to SQL Server 2000, record locks taking place in SQL Server preventing users from logging on and modifying records. The question is why does this happen when using Access 97 as front end. Access97 tables are linked via ODBC system DSNs to SQL Server Back end. Thanks for your help.

5 replies

by glen_mcleod

The record locking metod used by Access is irrelevent. SQL Server is doing the locks and giving you the errors. You'll have to track down where the locking option is being set.

It sounds like you're experiencing pessimistic locking and SQL Server by default doesn't run in that mode. Check with your DBA to see how your server has been configured to run.

Glen

by cking

Although this was not exactly the problem, the answer pointed us in the right direction. We found that by using a clustered index on the Employee Name field in the table corrected the problem. The Employee Name field is the most heavily hit field in the database and was causing the locking problem. Thanks for your help.

This discussion is closed to new replies.