Linked Table Manager (1 Viewer)

PaulO · Apr 20, 2009

Is there any way of editing/updating the Linked Table Manager other than through 'Tools'?

Rabbie · Apr 20, 2009

You may find this link to be helpful

PaulO · Apr 20, 2009

Thanks Rabbie ...

What I am actually trying to do is vary the links in the Linked Table Manager at Startup dependant on the directory name held in a standard Table in the Front End application.

So ... the Directory where the 'BE' file is stored could be, for example

C:\Program Files\MyWork
C:\MyWork
My Documents\MyWork
F:\MyWork (e.g. Network)

I want the Front End database to link to the 'BE' database plus any other sundry Excel and Text files in that particular, variable, location.

Hope that makes sense?

Rabbie · Apr 20, 2009

I am sure the code I linked to could be changed to do what you want. It would just be a matter of reading the location from your FE table and then linking to that directory.

PaulO · Apr 20, 2009

Okay ... I'll take a longer look at the VB coding to see where it could be varied to suit my requirement.

gemma-the-husky · Apr 20, 2009

paul

the best way to do this is to read the location from the table (i assume its a local table) and check if the connected location for a linked table is the same.

tabledefs("ATable").connect will be

;database=path......

------------------
if the path in the connect string is not the same then use some code to reconnect all the tables - there are lots of tools for this on here.

PaulO · Apr 23, 2009

Thanks Dave ... but have to confess this is way out of my comfort zone!

Linked Table Manager (1 Viewer)

PaulO

Registered User.

Rabbie

Super Moderator

PaulO

Registered User.

Rabbie

Super Moderator

PaulO

Registered User.

gemma-the-husky

Super Moderator

PaulO

Registered User.

Similar threads

Users who are viewing this thread