"Currently Locked by another session" Error

[Leesha]

Hi,
I have a query that can contain anywhere from 1-110's of email addresses. The user has the ability to delete/edit the ones they don't want added to a batch email, or that need to be corrected. They are stored in a temporary table so this doesn't affect where the addresses are permanently stored. They are getting errors on random rows that states "could not update due to being locked by another session on the machine". I can't figure out what is locking them. Is there code that will unlock them?
Thanks,
Leesha

[HansV]

Do you keep a recordset on that table open?

[Leesha]

I honestly don't know. Also, this wasn't happening before that I know of. It seems to be affecting the first 18 rows of the query. frmOutputEmailBatch is bound to qryEmailSent. The user can open the query from frmOututEmailBatch to make corrections or deletions to the records in qryEmailSent. It seems to be affecting the first 18-20 rows of the query. The rest can be edited or deleted.
Leesha

[HansV]

Do you mean that the user opens qryEmailSent while the form qryEmailSent which is bound to qryEmailSent is open? That might cause the conflict.

[Leesha]

I tried it with a different query than the one the form is bound to but still get the same error.

[Leesha]

Ok so I decided to "think like Hans" and I believe I found it!! The form property Record Locks was set to edited records. I put it back to No Locks and I appear to be ok.

[HansV]

Great!