Updating from an external Access table

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Leif (anonymous_at_discussions.microsoft.com)
Date: 06/30/04 

Date: Wed, 30 Jun 2004 10:28:01 -0700

I need to be able to update two different Access tables
from an external Access database. I think I have a
solution, but it seems ackward.

Right now I creating a link to the external Access table
using docmd.Transferdatabase. Next I run a query that
does an unmatched selection joining the external and
internal tables. The external table is accessed thru a
different query that does some filtering.

Once I'm done with the query data I need to go back and
remove the table link.

Is there a better way? Pherhaps I can skip the
link/remove link steps by updating the filtering query
with the external database file name?

Regards,
Leif

Relevant Pages

  • Re: Updating from an external Access table
    ... SELECT CustomerID ... > from an external Access database. ... > different query that does some filtering. ... > link/remove link steps by updating the filtering query ...
    (microsoft.public.access.modulesdaovba)
  • Re: Updating from an external Access table
    ... I know about the IN clause. ... this query, instead it is being used in a second query as ... >> from an external Access database. ...
    (microsoft.public.access.modulesdaovba)