Change the location of the database connection

[oldes]

I am using link_tables which are connected to a database in a seperate location.

(if necessary) I want to activate the Linked Table Manager of Access and change the location of the database connection of Access's default database Connection...

I tried but couldn,t find any reference to hot to call Link Table Manager programmatically..

1- How can I call Linked Table Manager ?
2- Assuming that they have same tables, is there a way to change connection programmatically from Database file to ODBC connection and vise versa..

Kind Regards

and Thanks for the effort !..

 

[boblarson]

Access MVP Armen Stein has a cool set of FREE relinking code on his page here:

http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

look for J Street Access Relinker. Use that and you won't need to code it yourself.

 

[boblarson]

Oh, and I changed the title to reflect the question instead of Hi All, which isn't a good title for a help forum.

 

[oldes]

Thanks Bob,

Sorry for the heading...

I am develop'ng a system cons'st of about 1080 forms and 350 tables; I appriciate all kinds of help...

kind regards.

 

[Rabbie]

This link may also be helpful

 

[oldes]

You are absolutely right..

However this project is an BIS consist of 14 different mangeement systems. Too some degree I am developing a SAP'like general management system for SMBs..
Thats the reason it is so large...