multi-user form can't get table

  • Thread starter Thread starter Mike D.
  • Start date Start date
M

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.
 
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
 
Back
Top