Delete Query

[luceze]

I have a table in the back end of my database that is stored on the server. When trying to delete a large number of records I am getting the error "Could not update; Currently locked." The most records that I can delete at one time is 241. Any more than that and it will error out. There are no relationships. Anyone know of a reason that this is happening? Using Access 2000 and Windows 2000.

 

[THWatson]

There is an article on the Microsoft Knowledge Base, article #241969, that may provide an answer to your problem. Maybe not, but it's worth a look.

Tom

 

[luceze]

Thanks. I had read that one already but it doesn't apply to my situation. I did some more testing and I could delete any number of records when the back end db was stored locally. I think it has something to do with the server and it's settings.