How do I refresh linked tables in a replicated database?
If you have code that deletes the linked tables and re-creates them, this will fail in all replicas except for the Design Master, because deleting linked tables and adding new ones are both considered design changes. In order to refresh the links, you’ll need to write code for your front-end replicated application that updates the Connect property (with the path/mdb name of the back-end database) of each attached TableDef object. Follow the update to the Connect property with the RefreshLink Method for each TableDef object to let the Jet database engine know where the new data lives. Fortunately, this is not considered a design change for the purposes of replication, so you don’t have to worry about the path propagating inappropriately to other replicas during synchronization. • How do I replicate an application that has implemented split data and code MDBs? You can replicate the application database, the table database, or both. However, you may find it more efficient in practice to o
