Updateting Tables From Previous Database

  • Thread starter Thread starter IC_Clearly
  • Start date Start date
I

IC_Clearly

I have several locations (10) who run an Access program (2K w/program and
data separate). The data at each location is unique. We find ourselves
frequently adding fields to a table or adding a new table and then
connecting or going to each location to manually make the change.

Is there a utility that will take a database that has all of our updated
tables and fields and then import just the data? If so, we could install
the new database in the office and then import the data from the other
database at that location. This would keep us from having to go into each
database to manually make these changes?

Thanks.

IC
 
Hi,
for such things i am doing following procedure - all changes to tables i
"script" (could be SQL scripts, or just some you do yourself, say "add
relation", which you recognize by your programm and execute) to special
table, stored in frontend. when i run frontend - i first check version of
backed, and if necessary - run "scripts" to update it to latest vesrion
 
Back
Top