Access Can't delete records due to lock violations -


We have been using a command command on Access 2003 with XP machine for the past few years and we are not upgrading To access our system 2010 and Windows 7.

Please see the error below. Not sure what I was remembering I tried to create a new link oracle table, but it does not work.

Enter image details when attempting to update a linked SQL Server table, I Just ran in the same lock error. I> </ p> </ div> <p> <div class =

MS Access 2010.

This is no longer a problem for you because the thread is too old, but hopefully it makes it easier on anyone else in the future.

I call it an int from the id field in Bil server Change it to alright Was capable of.

You might also want to make sure that is set to "Default record locking" "not" lock "Access Options - & gt; Client settings - & gt; Advanced

Comments