Multiple users adding new records at the same time with a form that has a lookup

[tshink]

Hi,



When I have more than one user create a new record in my form, I get a locking error when any subsequent user attempts to perform the same lookup on a new record at the same time. I have removed all lookups from the table level as noted in another thread. Is it possible to have more than one user create a new record on a form at one time in Access? How can this work? It does not appear that a subsequent user can create another new record while the first user is currently editing a new record and has it locked. Is it possible to create more than one new record at a time? What happens is, any user that tries to create a new record ends up on the same new record that the first person who created it is working on and not on a unique new record. For example user 1 creates a new record 85 of 85. When user 2 tries to create a new record then end up on record 85 as well and not record 86 until user 1 is completely finished with and has saved record 85. Is it possible for user 2 to create a new record 86 while record 85 is still being created by user 1. Any advice? Thanks.

[ranman256]

Is the database split? (tables vs forms/queries)?
If not, is everyone in the same database?

If not split, then do so. We've never gotten a conflict with a split db.

[CJ_London]

other question to ask is what is mean't by 'record 85'. Is this the primary key? and if so how is it generated? the key is an autonumber or being populated using dmax+1 or similar?