Locked Table

[CQ]

I have an Access 97 Database that is used by multiple
people. There is a specific report that gets run many
times during the day by these different people. The catch
is that one runs it, the tables are locked and then the
next person can't run it. Anything I can do to set a
property or something so that tables aren't "locked" for
person B when person A has just run the report? The real
catch is that if person B stays on the final page of the
report and goes to lunch, then person A is just out of
luck until Person B comes back.

 

[Van T. Dinh]

There is a "Record Locks" Property in the "Other" tab of
the Properties Dialog for the Report. You can set it
to "No Locks" so that other users still can use the Table.

HTH
Van T. Dinh
MVP (Access)

 

[CQ]

Thank you for your help.

-----Original Message-----
There is a "Record Locks" Property in the "Other" tab of
the Properties Dialog for the Report. You can set it
to "No Locks" so that other users still can use the Table.

HTH
Van T. Dinh
MVP (Access)



.