MSYSobjects

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a billing Database and have Multiple links to various databases.

I have also several Billing Archives to which I need to connect to, however I have to establish about 25 links manually through the linked table manager and then have to restablish the links back to the latest months database. As the linked table manager displays the table names alphabetically and not by connection string.

If I know the id in MSYSOBJECTS to which tables I want to ammend the links can I then update the links using code from a look up table containing the following fields.

MSYSObjects id
Database (connection String)
Billing Month

So if i want to select a billing month I can look up the MSYSobjects ID and ammend the Database field in MSYSobjects.

As I have to change the links on a regular basis any assistance would be much appreciated
 
AFAIK, you cannot update the MSysObjects table directly.

Take a look at code sample http://www.mvps.org/access/tables/tbl0009.htm at
"The Access Web" for how to relink through code.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Colin said:
I have a billing Database and have Multiple links to various databases.

I have also several Billing Archives to which I need to connect to,
Click to expand...
however I have to establish about 25 links manually through the linked table
manager and then have to restablish the links back to the latest months
database. As the linked table manager displays the table names
alphabetically and not by connection string.
If I know the id in MSYSOBJECTS to which tables I want to ammend the links
Click to expand...
can I then update the links using code from a look up table containing the
following fields.
MSYSObjects id
Database (connection String)
Billing Month

So if i want to select a billing month I can look up the MSYSobjects ID
Click to expand...
and ammend the Database field in MSYSobjects.
As I have to change the links on a regular basis any assistance would be
Click to expand...
much appreciated
 
Hi Doug,

I knew that you could not update directly but the link will be very useful.

Many thanks

PS Ienjoy a few beers also
 
Back
Top