[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