Import or append to updated database

G

Graeme at Raptup

I designed a database that is now in use and data has been added and updated.
In the meantime I have worked on a 'mirror' of that database and added new
forms, reports and tables. (I have not changed existing tables or queries)
Now I want to udate the data in the 'New' database.
What is the best way of doing this?
 
A

Allen Browne

Split the database. You can then update the front end without overwriting
the data in the back end.

There's a wizard to do it for you:
Tools | Database Utilities | Database Splitter

More info:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html
 
G

Graeme at Raptup

Hah,
now I know what that's for! Thought it was just so users did not get to
tamper with design! Thanks.
While I'm about it would you mind having a look at a thread for me? Called
"Subform numbers" (19/12/2005) re: numbering rows in a subform.
 
Top