Record Locking

R

Randy

I have a Access program that has two users. I split the program and
have two users. One keeps getting lock ups when trying to enter a new
record even though the other person is not working on a record, but
both have the program open. The one that is having the problem is
using the new record icon at the top of the window.

Is there something I can do to fix this?

I don't want to use No Locks as I don't want them losing data.
 
M

mscertified

We have tons of complex Access apps with a lot more than 2 users and we use
'No locks' for everything. A message will be displayed if two users are in
conflict. Its a pretty rare occurence.
Conflicts have a lot to do with how you designed your app. Only one record
should be accessed at a time.

David
 
Top