I
ITperson
Hello
I have 261 table that are linked.
When I do maintenance on my db, I use a local copy. In the linked table
manager, I see all the linked tables.
When I implement my changes to the server, I copy my local copy of the db to
the server. But: the database paths for the linked tables still reflect my
local system.
I have 1 of 3 dbs that the tables are linked to (temp.mdb, hist.mdb or
data.mdb).
My idea is this (although if you have a better solution, Im all ears).
Create 3 arrays where each array will contain the names of the tables for
each db. Then take each array and write the tablenames to the linked table
manager.
However, "How do you do that?"
I have 1 array that would hold 155 tablenames, but I cannot figure out how
to get the names into the array. I have written some code in excel that
concatenates the tablenames to "Arr_temp(var)=tablename" (is this correct?
But I also need to delete all the linked tables in the linked table manager
before creating these new ones.
The reason I need to do this is because it takes me at least 40Minutes to do
this and I have to do it several times a week.
Thank you for your help and input.
Terry
I have 261 table that are linked.
When I do maintenance on my db, I use a local copy. In the linked table
manager, I see all the linked tables.
When I implement my changes to the server, I copy my local copy of the db to
the server. But: the database paths for the linked tables still reflect my
local system.
I have 1 of 3 dbs that the tables are linked to (temp.mdb, hist.mdb or
data.mdb).
My idea is this (although if you have a better solution, Im all ears).
Create 3 arrays where each array will contain the names of the tables for
each db. Then take each array and write the tablenames to the linked table
manager.
However, "How do you do that?"
I have 1 array that would hold 155 tablenames, but I cannot figure out how
to get the names into the array. I have written some code in excel that
concatenates the tablenames to "Arr_temp(var)=tablename" (is this correct?
But I also need to delete all the linked tables in the linked table manager
before creating these new ones.
The reason I need to do this is because it takes me at least 40Minutes to do
this and I have to do it several times a week.
Thank you for your help and input.
Terry