J
Jonathan Bickett
I have linked tables in a replicated database in which the server the
linked tables reside on will be changing names. I'd like to refresh
the links in the design master and then have it update all the
databases in the replica set automatically.
I have found this solution on the Microsoft website:
# If you use linked tables (linked table: A table stored in a file
outside the open database from which Access can access records. You
can add, delete, and edit records in a linked table, but you cannot
change its structure.), keep in mind that linked tables aren't
automatically replicated. If you create a linked table in the Design
Master, it's created as a local object and remains local until you
make it replicable. When you make the table replicable, the link and
the table are sent to all the replicas in the set. After the table
appears in each replica, you can change the link in an individual
replica or in the Design Master without affecting the other members of
the replica set. To refresh the link in all members of the replica
set, change the replicable linked table to a local table (in the
Design Master), refresh the link, and change the table back to a
replicable table.
The last sentence says to change teh replicable linked table to a
local table, change the link, then change the table back to a
replicable table. I'm not sure how to do this. I'm using Access
2003. I can't find any options to make change a table from being
replicable to local or vice versa. Please help.
Thanks!
linked tables reside on will be changing names. I'd like to refresh
the links in the design master and then have it update all the
databases in the replica set automatically.
I have found this solution on the Microsoft website:
# If you use linked tables (linked table: A table stored in a file
outside the open database from which Access can access records. You
can add, delete, and edit records in a linked table, but you cannot
change its structure.), keep in mind that linked tables aren't
automatically replicated. If you create a linked table in the Design
Master, it's created as a local object and remains local until you
make it replicable. When you make the table replicable, the link and
the table are sent to all the replicas in the set. After the table
appears in each replica, you can change the link in an individual
replica or in the Design Master without affecting the other members of
the replica set. To refresh the link in all members of the replica
set, change the replicable linked table to a local table (in the
Design Master), refresh the link, and change the table back to a
replicable table.
The last sentence says to change teh replicable linked table to a
local table, change the link, then change the table back to a
replicable table. I'm not sure how to do this. I'm using Access
2003. I can't find any options to make change a table from being
replicable to local or vice versa. Please help.
Thanks!