Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import/Update database

Status
Not open for further replies.

Tyfos

Technical User
Sep 24, 2000
5
DK
I've build an Access database for a firm. After a while they got com changes they need, and here is to big question?
Is it possible for me to make the design changes at my PC, then give them a file and then they can update the database?
If it is possible, then how?

Tnxs....... [sig][/sig]
 
The easiest way that I know of to do this is to take a copy of their database and make the code changes to it. Once you have tested all of your changes, empty the data from your tables and import the data from their database into your new database.

You may want to make two copies of their database, one for you to make the changes to and one to test the import with.

Hope this helps...
[sig]<p>Terry M. Hoey<br><a href=mailto:th3856@txmail.sbc.com>th3856@txmail.sbc.com</a><br><a href= > </a><br>Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?[/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top