Linked table in Access 97 using VBA code ???? 
Author Message
 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.
:
:
:



Mon, 22 Jul 2002 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. vba code to copy table from access 97 to excel 97

2. filtering records, using dbgrid linked to an access 97 table

3. ADO using 3.51 with Links to Access 97 tables

4. Creating Modules in Access 97 using vba code

5. Access 97 - Modifying Table Links

6. Re-linking tables from MS ACCESS 97 back end

7. Using VBA to Convert Access 2000 database to Access 97

8. Linking SQL7 Tables to Access 97 via SQLDMO?

9. Seek not valid in linked tables (Access 97)

10. Saving embedded word 97 docs in Access db with linked SQL Server tables

11. Updating linked table info in Access 97 database

12. Programatically change Table links in Access 97 database

 

 
Powered by phpBB® Forum Software