[AccessD] Relink temporarily

Hi Vlad

Oh, thanks, if only I was. 
That would minimize my to-do list within a few seconds - and at the
same time add a lot of new hot topics with quite wide coverage!

Well, back to work ...

/gustav

>>> actebs at actebs.com.au 29-08-2005 15:13 >>>
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