Select the Data Source

A

attie

Hi,

I would like to know if there is a way to specify the path of an mdb file or
select the SQL Server where the database is where the linked tables come
from, ensuring that an application is customizable programatically in any
environment.

Thanks
 
D

Dirk Goldgar

attie said:
Hi,

I would like to know if there is a way to specify the path of an mdb
file or select the SQL Server where the database is where the linked
tables come from, ensuring that an application is customizable
programatically in any environment.
Click to expand...

See these links:

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

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

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