Updating existing MS Access solution

MrG

New member
Local time
Today, 18:34
Joined
Jul 6, 2005
Messages
7
I have searched the forum but have failed to find the answer to my problem. I have a front end ms access 2000 solution that I distribute to user PC's with an MDE back end data base on a server.
I now need to release a new version that includes changes to forms, queries and tables.
However there is data in the original mde data base I need to retain. Is there an easy method to migrate that data to the new data base. I have changed some relationships but this should not affect data integrity - most change is related to adding new fieldsto existing tables or new tables (no previous data).
If I create a new empty mde will I be able to import old data into it from previous mde?:confused:
 
For anybody who may have the same problem I achieved the update to the data base by recreating an MDE file - splitting the new data base and then exporting the data from the old data base into Excel and re-importing into the new data base. Only fieods from the old db were loaded - don't know what would happen if I had deleted some fields though.
 

Users who are viewing this thread

Back
Top Bottom