Question linking - relinking

[SparkByte]

Figures just after I 'clean' my old files.

I had a sample MDB that had a table and a module that you can add to an exist mdb/accbd.

Once added to your front-end.

run the module to add all the linked tables to the LinkedTableList table (for lack of its real name).

The table list held pretty basic info. Remote Table Name, Local Table Name, ConnectionString ...


In the module you could run getlinkedtables, relinktables, and such.

I think it may have even had a menu associatede with it.

Anyone remember seeing anthing like that?? Or have something simular?

Thanks
John

 

[CJ_London]

google 'access automatic relink' or similar, there are plenty of links - here is one

http://www.databasejournal.com/features/msaccess/article.php/3586401/Automatic-Table-Relinking.htm

 

[SparkByte]

Yes I had found several table relinkers but non deal with ODBC linked tables. Specifically SQL server client version 10.

I found Peters Software where he has TableLinker as a free download. This is close and can handle ODBC linked tables. I think that with a few mods it will do what I need.

Thanks
John

 

[CJ_London]

but non deal with ODBC linked tables

The principle is always the same - but each type of datasource uses a different connection string.

this site is very useful

http://www.connectionstrings.com/