Locking problems

[Peter Carlsson]

I'm running Access-97 db with tables linked to SQL Server
7.0. When two user access the same record one of them get
this message:

"Couldn't save; Currently locked by user <xx> on machine
<machineName>"

The access db is shared and have no locks on any records.

How do I solve this problem?

/Peter

 

[Pete Sheridan]

Peter,

Check the SQL db and make sure that each table contains
both a 'Primary Key Column' and a 'Timestamp' column.

Secondly, include these fields in every 'view' that you
link to from the 'Access db'

Third, include all of you indexed fields in the 'Access'
queries.

Fourth, When Access is used as the 'frontend' for a
SQL 'backend' db, SQL will handle the record locking
regardless how you have the Access re3cord locking options
set. Make sure that you set up SQL properly.

Hope this helps, Pete