Access QUERY locks tables

[warthog72]

Ok, I'm trying to execute an UPDATE query that occassionally says it can't perform the UPDATE because the data is locked by another session on my computer. This only happens every once-and-a-while, not all the time. If I terminate the code and move the main form to another record and try again - no problem it runs. This is not a feasible solution because there are many users using this application in a run-time environment.

HELP!!

Thanks,

Steve

 

[BNPMike]

If you run an update query you will get locking. Locking prevents simultaneous updates corrupting the database. What exactly are you expecting to happen here?

 

[warthog72]

There isn't any data that should be locked at the time I run the query. For 99% of all times this query is run its completely fine, the query runs, the data gets updated, no problems. There is a small occurence (and now it seems to be with specific records only) that causes the UPDATE query not to execute because of locking.

The funny thing is, I can take the exact same query (copy the string) and run it a few minutes later without the application running and POOF! All is well. How does ACCESS lock data when performing an UPDATE query and more importantly, how can this data be locked when I'm the only one running the UPDATE query

Maybe I have some faulty database pages???

Thanks for any help!!