Ok I have a Master development version of my database and multiple versions of the same database with different names and the data will be different for each.. I need to keep all the versions in sync, however they are become unruly - I would like to create a process that will allow me to automatically push the changes to the various mdbs with the click of a button.
I have a list of objects to be exported or imported - not sure which is the best process yet.
a list of the tables to be imported into the newly copied version of the Master.mdb prior to renaming the mdb and replacing it in the correct location. Also I would need to backup the previous version of the individual mdb prior to replacement.
I have a list of databases and their locations.
I am unsure of the best approach to either loop thru the list of databases either push to newly revised objects to the databases or whether to take the Master, rename it and import the live data tables with relationships to create the last version of the database.
I believe that taking the entire Master version, renaming it, replacing the tables & relationships seems to be a cleaner way, then replacing the chlld database.
What do you think would be the best approach?