Change Linked Table With Vba

D

DALIEN51

Registered User.

Local time

Today, 04:13

Joined

Feb 26, 2004

Messages

77

• Mar 16, 2006

• #1

Is it possible to change which table in an external database that my linked table is pointing to using VBA? (Access 2000)

Example code appreciated!

Regards

 

L

Len Boorman

Back in gainfull employme

Local time

Today, 04:13

Joined

Mar 23, 2000

Messages

1,927

• Mar 16, 2006

• #2

do not think you can change the design of a linked table with VBA or indeed purely by selecting the table in question and putting into design mode

Len

 

J

Jerry Stoner

Guest

• Mar 16, 2006

• #3

Just delete the current linked table
DoCmd.DeleteObject acTable, "c3_ccs_wtwproductprice"
Then link a new one
DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;DSN=C3AMP;UID=C3read;PWD=connect3;LANGUAGE=us_english;" & "DATABASE=connect3", acTable, "ccs_wtwproductprice", "c3_ccs_wtwproductprice"