Record locking error

imwalrus38

Registered User.
Local time
Yesterday, 16:52
Joined
May 27, 2005
Messages
31
:confused: I created a data base in which 4 users enter information using a form. I have no record locking applied. When 2 or more of the users enter the form at the same time but have not entered any information they get a record lock error when one of them tries to enter data. The company wants to open this up to more people so I need to stop this from happening. Any ideas? I'm using access 2003 and windows xp.

Is there a way to assign a new record upon opening the form rather than waiting for data to be entered? I think this would be my last resort because it could create alot of blank records. All help is appreciated.

Thanks
John:confused:
 
Hi imwalrus38

Goto "Tools", "Option", "Advanced Tab".

What do you have your "Default open mode" set too?

Shared or Exclusive?

What do you have your "Default record locking" set too?

1. No Locks
2. All records
3. Edited record

Look forward to your response.

Robert88
 
Default open mode is shared.

Default record locking is no locks

Open data base using record level locking is checked.
 
still need help

I'm still stuck on this anyone have any Ideas?

Thanks
j
 
Just go to your forms property (in design mode), click the Data tab, at the bottom you will see Record Locks, click the dropdown to view the various options...

If you are pulling data from a query, you could also look at the query properties...This should fix your problem...Edited Records would work with multiple users...They will be given a message on who is editing, if being done, etc...Check it out...
 
Hi imwalrus38,

Sorry for not getting back earlier.

Your "Default record locking" should be set set to one of the others?

2. All records
3. Edited record

Otherwise with "no locks", when people use the table and/or query at the same time the table will not know exactly when to lock either out if they both conduct edits at the same time.

For memory you might have to create a new database shell, mdb file and import everything into it, I could be wrong.

I know I have had this problem with shared databases and think that this issue is also the same, but I could be wrong?

Try it and let me know, sorry for the late response.

Robert88
 
Thanks

Thanks going to forms property and changing to edit record did the trick. i appreciate your help:) :)
 

Users who are viewing this thread

Back
Top Bottom