I used the security wizard to set up a shared database which is
accessed by several users. Record-level locking is working fine to
allow multiple users to enter data at the same time. However, it is
not possible to run reports if anyone else is entering data: Access
gives an error message that it can't lock the table underlying the
report as another user is editing it. Is there an easy fix for this?
Thanks!