multi-user form can't get table

[Mike D.]

Here's the error I get when a 2nd user tries to use the
form -
"The database engine could not lock table 'Table1'
because it is already in use by another person or
process".

I have the default open mode set to "shared" instead
of "exclusive". What am I missing here?

Thanks,
Mike D.

 

[Dave]

Could your form's RecordLocks property be set to All
Records? That would do it. If so, set it to Edited Record
This can also be set at the database level under
options/Advanced

 

[Mike D.]

That's it! Thank you very much for saving much
aggravation!

Mike D.