Import or append to updated database

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

Guest

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?
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
Using Append to Update & Calculate Data 10
append query (data comming from excel Table link) 1
Replacing a Table with a Table from another database - reference issues 1
Import and Append of txt files 1
Append query bloat 4
Split database loses information 7
query to append and update? 4

Back
Top