Programatically Linking Selected Tables to BE

[TSIsolutions]

Hope a guru can help.

I have a split DB. The FE contains to types of tables: the first are Permanent tables linked to the BE and Temporary table that reside on the FE.
When installing a FE on a workstation, I would like to programatically link ONLY the Permanent tables to the BE. Thinking proactively, I added a TMP prefixe to each Temporary table.
My guess is to cycle through each table and whichever doesn't have a TMP prefix then connect to the BE. Or I can create a table listing all Permanent tables and using that to connect to the BE.
Can anyone tell me how to do that?

Thanks,
Lawrence

 

[traingamer]

You don't need the 'TMP' prefix. The database knows which tables are linked tables. You can loop through the TableDefs in the database and check the .Connect property to figure out if it's a linked table and connect accordingly.

OR

No programming needed:
Tools->Database Utilities->Linked Table Manager
check 'Always Prompt for New Location', select all and browse for the location.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill