current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

We have been using a Delete command on Access 2003 with xp machine from past few years and it was working good until we upgraded our systems to Access 2010 and Windows 7.

Please see the error below. No sure what i was missing. I tried creating a new link oracle table, but it didn't work.

enter image description here

share|improve this question
    
Are you sure you still have a unique key? Sometimes you have to assign them when you link the table. –  Fionnuala Jul 10 '12 at 9:46
    
It still runs good with Access 2007 on XP machine. –  vamsivanka Jul 10 '12 at 12:13

3 Answers 3

up vote 1 down vote

I just ran into the same lock error when trying to update a linked SQL Server table via MS Access 2010.

This may no longer be a problem for you since the thread is so old, but hopefully it makes it easier on someone else in the future.

I was able to fix it by changing the ID field in SQL Server from a bigint to an int.

You may also want to make sure that "Default record locking" is set to "No locks" in Access Options --> Client Settings --> Advanced DefaultRecordLocking

share|improve this answer
up vote 1 down vote

I had this error with a linked table that had a primary key and a unique key. When linking the table, Access assumed the unique key was the primary key.

By temporarily disabling or deleting the unique key and refreshing the ling using Linked Table Manager" the problem was resolved.

share|improve this answer
up vote 0 down vote

It appears that the 332 records it can't delete are locked, perhaps by some other process? Is there a stagnant process running somewhere that is holding a lock on those records?

share|improve this answer
    
No stagnant process running. when i use the same file with Access 2007 on XP, it deletes all the records at once. –  vamsivanka Jul 10 '12 at 12:03
    
Start listing out the differences between the machines. You've already noted the operating system and versions of Access, so keep going. It doesn't seem like those two differences would cause what you are experiencing, so perhaps there is some other difference that is causing this. –  Nick DeVore Jul 10 '12 at 14:54
    
@NickDeVore...No other differences exists. –  vamsivanka Jul 19 '12 at 14:01

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.