Importing data to changed tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a database that I designed and am continually up grading. The
database is being used by mutliple stand alone users in the field. After
updating both tables, forms and reports I need to get the others users data
into the data base. Import is good except that if Ive changed table
information.

What is the best way of import ONLY the user data into a newly desined data
base?
 
Link to the old tables, use append queries to copy the data from the old
tables into the new ones.
 
Replication might be the answer.

You may also consider a web solution like Active Server Pages so that they
put the data directly into your one copy of the database.
 
That will take care of new records, but will not include existing records
that have been updated.

It appears to me from the OP that he is not using a front end / back end
model, rather all objects are in one mdb.

The real solution here is to use the database splitter to move the data to a
back end mdb so that all data is in one mdb and all other objects are in
another. Then the front end (forms, reports, etc) can be replaced with a new
mdb without disturbing the data.
 
Back
Top