• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 44
  • Last Modified:

ACCESS SQL SERVER ODBC RECORD LOCKED

Hi Folks,
When the user attempts to edit or delete a record in a linked SQL Server table they get the error:
The Microsoft Office Access database engine stopped the process because you and another user are attempting to change the same data at the same time.
Initially I thought this was true (because another user was editing the same record) but, after creating a whole new set (FE and database) the problem remains, when there is only one user.
it is a 2007 Access database, and I have tried the BE on 2012 and 2017 SQL Server.
thanks for any input
0
COACHMAN99
Asked:
COACHMAN99
  • 2
1 Solution
 
bfuchsCommented:
try creating a timestamp field on the table, in my cases it helped.
0
 
COACHMAN99Author Commented:
seems to work - thanks very much
why do you suppose this is the solution?
0
 
bfuchsCommented:
Also faced this issue and was told to do that..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now