Hi
I have written a reservations and invoicing system for a resort.
The reception keeps a browse of the invoices open all of the time with
updates linked to this. They also have an excel bookings screen open that
is
populated and refreshed by the program at various intervals.
The problem is that sometimes when updating or creating an invoice the
update will fail because of the error: "the connection is busy with
results
from another hstmt"
When I remove the bookings screen refresh then this problem stops.
Can anyone give me any advice on how to solve this problem without
removing
the refresh.
I have looked at the driver options but couldn't seem to solve problem.
Thanks
