
Linked table in Access 97 using VBA code ????
Take a look at CreateDatabase in Acces shelp. Once you have the database,
you can specify the path to this new db in the current db's tabledefs'
.Connect property to establish a link.
tdf.Connect = ";Database=" & strNewDBPath
tdf.RefreshLink
As for emails, sorry, that's not possible. Read
< http://www.*-*-*.com/ ;
-- Dev
:Hi,
:
:I have a 2 Access 97 DB's one for the actual data and one with the
:application and linked tables to the corresponding data ones.
:
:Is there any way in VBA code that I can : from the application DB create a
:DB in the data DB and then create a link to it ???
:
:Bye
:Peter
:P.S Please email me direct if possible, same address as this message.
:
:
: