Table Locking and Printing Reports

[Adzi]

Hello,

I've designed a system that allows the user to take campsite bookings. Once the booking has been taken, a report prints.

I though I set the database up so that the records are locked on an individual basis, however when two or more people are using the system (i.e. taking a booking) the report won't print with a run time error of not being able to lock the table.

Is there anything i'm missing?

Regards,
Adam

 

[Galaxiom]

A stab in the dark:
Maybe try using a query as the RecordSource of the report.
Set that query's RecordSetType as Snapshot.