🚀 go-pugleaf

Instead of using Requery, try closing and then opening.  

-Jerry


On Sun, 6 Oct 2002 16:50:55 +0100, "MarkR"
<mark.richards8@wapthespamntlworld.com> wrote:

>I have a very simple app which has an ADOTable component, a DBGrid control
>which holds all the key records, and a selection of DBEdit controls which
>allow indiviual fields to be edited, All these are also connected to a
>DBNavigate control.
>
>The database is MSAccess2000.
>
>Basically, I want to have two of the same app running on the same machine at
>the same time. When I do this, everything is fine until I delete a record in
>one app, and then do a ADOTable1->Requery() on the second app, I get an
>error saying
>---------------------------
>Debugger Exception Notification
>---------------------------
>Project caldervale.exe raised exception class EOleException with message
>'Key value for this row was changed or deleted at the data store. The local
>row is now deleted'. Process stopped. Use Step or Run to continue.
>
>What do I need to do so that the second app doesn't fall over?