[AccessD] Relink temporarily

Thanks Gustav - you're a god!! 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Monday, 29 August 2005 6:16 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Relink temporarily

Hi Vlad

You can use IN in a select query for this:

  SELECT 
    *
  FROM 
    tblTable IN "" [;DATABASE=d:\folder\file.mdb;];

This will not even link the table, just open it.

If you need an actual linked table, use DoCmd.TransferDatabase with the
constant acLink and delete the table when finished.

/gustav

>>> actebs at actebs.com.au 29-08-2005 02:05 >>>
Hi everyone,
 
Does anyone have a procedure that they are willing to share that can
temporarily link a table and then once finished removes the link from
the DB? I am using A2K for a small app and just can't seem to find any
info on this...
 
Thanks in advance
Vlad

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com