Record Lock on query search

[Larryg]

Hello;



Weird question (at least for me) concerning record locks on VBA query searches using a text string. I have a text (combo) box on an unbound form that triggers a VBA query, that creates a recordset, which populates a form. The issue I'm experiencing is the user can select from about 10 names to search on. All name searches work fine, but when one user selects a name that is similar to a name that another user selects, they get a record lock error. Retrying the search in a few minutes returns the same error. However, if that same user selects a different name, the search run fine. The only thing the two name gave in common is the first 3 letters of the two different names, are the same. Is it possible that Access only looks at the first few letters of name and locks any subsequent search for a name similar?

Thanks...

[ranman256]

Is this a split database with muti users?

[Larryg]

Is this a split database with muti users?

Yes, Access 2010

[ranman256]

Odd that there would be locks.
you could try using snapshots to view data,(instead of dynasets)
but when the user wants to edit a rec, use a dynaset.

[Larryg]

Odd that there would be locks.
you could try using snapshots to view data,(instead of dynasets)
but when the user wants to edit a rec, use a dynaset.

What is really weird to me is that if they chose unlike names to search/load on, there is no problem. It's only when user #1 loads "Smith", and user #2 attempts to load "Smithsonian". User #2 can't load his "Smithsonian" until user #1 exits their screen with "Smith" loaded. Same users can load "Smith" and "Jones" at the same time without an issue.

Re your suggestion on snapshots v dynaset, they are not really editing the actual record in the table, a) because it's an unbound form, and b) when they do make a change it files the changed record to another completely different table. I currently do have it set at dynaset, so maybe I could try snapshot. Can't hurt as a test.

Thanks...