Please help with a serious issue

Hello,
I have written an order entry/inventory/reporting app.
I am using an ADOConnection component with many ADOTables. The software is
run from the client machines and connects to an Access db on the server.
I keep getting "row cannot be located" message, but i am not using any
triggers that i am aware of. I only use one ADOQuery component to empty a
temp table.

Also, i am using alot of filter statements to get the appropriate data for
the customer, such as their credit card(s), shipping addresses etc. The
thing is my filtering is messing things up for other users. In other words,
i have the cursor set to useclient, but it still seems to be having problems
when multiple users are doing the same things at the same basic time. If one
is taking an order, and another is trying to invoice an earlier placed
order, the invoice shows the credit card for the customer the order taker
had selected last. I have removed the filters after the order is placed, but
still get this problem sometimes.

any help would be greatly appreciated, ecpecially for the "row cannot be
located" message.
Thanks in advance,
Dave

Delphi 7 pro
Access 2000
Windows 2000/XP


.