Change the Link of tables by Code

[Guest]

Dear Friends,

Can I change the link of table by code? My application run on the pre-set
link tables (I have split the table and forms into two access files). For
some reasons, I want to change the link to other access files, how can I do
this.

Thanks a lot

Jack

 

[Guest]

Hi Jack,

Try the following samples from The Access Web:

Relink Access tables from code
http://www.mvps.org/access/tables/tbl0009.htm

Relink tables from different datasources
http://www.mvps.org/access/tables/tbl0012.htm

Relink ODBC tables from code
http://www.mvps.org/access/tables/tbl0010.htm


Tom
___________________________________

:

Dear Friends,

Can I change the link of table by code? My application run on the pre-set
link tables (I have split the table and forms into two access files). For
some reasons, I want to change the link to other access files, how can I do
this.

Thanks a lot

Jack