Re: Please help with a serious issue

Sounds like you might need some Primary Key indexes.

-Steve-


"dave" <bracken_dave@xxxxxxxxxxx> wrote in message
news:43de6f4e$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> 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
>


.