Locking records in a form

[imwalrus38]

I have 4 users entering data via aform. The database is located on a shared drive. They are getting errorsthat the record is locked. I believe this happens when 2 or more people open the form and are trying to enter data at the same time. Is there a way to have each person lock a new record on open at the form? or is there a better way to handle this? I'm new at this and am working my way through.


Thanks

John

 

[llkhoutx]

Are you using A97? If so, record locking for A97 is at the page level, which would involve multiple records.

If A2K or higher, record locking is at the record level. Be sure the Options | Advanced "Default Record Locking" 'No locks' radio button is pushed.

Are multiple users access the same record at the same time? What's the reason for this?

I have large multi-user mdbs with no record collisions.

 

[imwalrus38]

We're using access 2003. It happens when 2 or more open the form in add mode. A record number isn't assigned until the user enters the first bit of data to the form. If the first person to open the form (in add mode) doesn't enter any data and a second person opens the form in add mode they both get the record locked error when they try to add data.


thanks
J

 

[llkhoutx]

In response

As I said in my prior posting:

Be sure the Options | Advanced "Default Record Locking" 'No locks' radio button is pushed.

 

[imwalrus38]

Be sure the Options | Advanced "Default Record Locking" 'No locks' radio button is pushed.

The settings are set as you indicated but it still happens. I think it's becasue meither person is actually in a record. They are both on a blank form and haven;t started to add a record yet. When one starts to enter data thats when they get the record is locked message.

Thanks J