can't make changes because . . .

[Greg B]

We keep getting messages that state that we can't make
changes because the record is in use by another user.
How do we deal with this?

 

[Gary Miller]

Greg,

Now that you know a little more about it, you have probably found out that
Access will lock some adjoining records in a block called a page. In
sophisticated databases sometimes the developer will check the record first
to see if it is locked and then try to figure out how to deal with it. There
is another group here that focuses on the multi-user challenges.
microsoft.public.access.multiuser

Gary