mulitple users on a shared form

[bgseib]

I have a form that is used to update some tables, and I have it located on a network drive. What I am trying to do is get around the form lock or table lock error I get when I am on a form and another user tries to get on that form, and they get an error stating they can not update, cause it is in use by another user...

Any thoughts??

Thanks,
Brian

 

[The_Doc_Man]

You need to look in a couple of places that might help. (But it is not a guaranteed solution in all possible cases.)

The form probably has its recordlocks property set too restricted. You want the form to be able to lock only the edited record rather than the whole table. This is a property of the form as a whole rather than of any control on the form.

The other possibility is if a sub-form is involved, it has a separate recordlocks property that also must be set correctly.

Now, you COULD set the recordlocks property to no locking, but that is incredibly dangerous. It leads to the phenomenon called "destructive interference." Definitely not a good thing. You lose a lot of data that way.