[AccessD] Yes. Another Silly Access Question.

>My question was, "How can I peel off one record of an
>external table by using it to create a temporary local
>table and deleting the record from the back-end
>table?"


Hopefuly you have a unique key?

Run a Make Table query or delete / append queries to create the local copy 
of the record. Then a delete query against the main shared table.

Gary Kjos
garykjos at hotmail.com

_________________________________________________________________
Enjoy MSN 8 patented spam control and more with MSN 8 Dial-up Internet 
Service.  Try it FREE for one month!   http://join.msn.com/?page=dept/dialup