Table Linking Info

[JACKSON]

Hi

Does anyone know if there is a way to set the table linking information manually. I know how to use the Link Table wizard, but would like to set something up where I could reference the appropriate linking information from a table. This is because we deploy our application at different sites, which all have different network server addresses for the backend database. When we deploy an upgrade, we need to relink from each workstation to the appropriate backend (or at least re-link one and then copy & past at each workstation). I would like to pre-package the frontend with the appropriate links to the backend for that specific client. I am thinking there must be a hidden table somewhere with the backend file link info in it, but I have been unable to locate ??

Thanks

 

[JACKSON]

Hi Everyone,

I found it. It's MsysObjects table. I just needed to view the system objets and hiddden files in the database.

Thanks anyway

 

[JACKSON]

Hi Folks

I spoke too soon. Seems I am unable to actually edit fields within that file. I even checked for permissions and signed in as the owner of the table. When I view the table, it shows up as faded. I was trying to create an update query that would change the "Database" field within the MsysObjects table to the appropriate backend file links, as long as the foriegnname filed has a value.

In the end, the system would not let me edit those field values. Does anyone know of a way to do this or are these system table files just un-editable ?

Thanks

Jackson

 

[ghudson]

You are playing with fire if you attempt to edit the data in a systems table. They are usually not editable and for good reason why they are hidden by default.

 

[JACKSON]

I knew someone was going to say that to me, but I was just wondering if anyone had done it. I was actually just looking to change the [database]field for records that had [foreignname] values. Basically, i wanted to manually change the linked table information to allow me to pre-package the application with the correct table links prior to deploying at a client site. It's just a pain to re-link at the client site every time you do an upgrade, and unfortunately client network and server names exist prior to our installing our application so it's difficult to keep to one server directory name structure.

Anyway, I know where your comming from so thanks for the feedback, but I have to believe ther is a way to achieve what I am trying to do.


Jackson.

 

[Pat Hartman]

You can't change the MSys tables directly but you can use VBA to modify the connection string via the tabledefs collection. I don't have any code to post but you should be able to find a sample to get you started in help.

 

[JACKSON]

Thanks Pat ! I will do some research on that.