CurrentDb().TableDefs("myTable").question 2

[OhioSteve]

I want to interact with the linked table manager programatically. I have a reference to DAO set. I know that the property used for linked table connections is~

CurrentDb().TableDefs([table name]).Connect

When I output that as a string, I get values like~
";DATABASE=C:\acme\sales.mdb"

I tried to set the property using this command~

CurrentDb().TableDefs("itemDetails").Connect= ";DATABASE=C:\acme\marketing.mdb"

That executes without an error, but it does NOT really change the source of the linked table. Please advise.

 

[Remou]

Try:

Dim db As Database
Set db = CurrentDb
strConnect = ";DATABASE=C:\acme\marketing.mdb"
db.TableDefs("itemDetails").Connect = strConnect
db.TableDefs("itemDetails").RefreshLink

 

[PHV]

Have a look here:

http://www.mvps.org/access/tables/tbl0009.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[OhioSteve]

You both helped me alot, and you both get stars!