Resaving ACCESS Program without disturbing Data?

[DeeJay Johnson]

I have completed and sent an ACCESS 2007 application to a friend. Now she wants me to update the program, but she has saved a lot of data in the meanwhile. How can I update the program on my computer (I do not have her data on my computer), send it to her and have her download the revised program onto her computer without destroying all the data she has previously saved? Is there separate 'Save' routines for applications vs. data? If so, what are they?

[johneecc]

I might be misunderstandin g, but is this an Access VBA application you created within Access?
If she sends you her Access application it should have all the data and you could open it up and copy the tables for her file to your Access file.

[NeoPa]

This breaks down into two parts :

1. Fundamentally, this is done most easily by using Front-End / Back-End (FE/BE) databases. The FE is the application and the BE is the data. It may sometimes be necessary to reissue the BE, but much more rarely than the FE.
2. Updating the single, or BE, database. The simplest way to do this would appear to be importing them into a copy of your database. If the formats of the tables haven't changed then :
   1. Make a copy of the database you intend to release.
   2. Delete the same tables in the database copy that you want to get from the earlier released version (That populated by your friend/client).
   3. Import the tables from the earlier version.
   4. Release this new, updated version back to the client.

If there are any restrictions due to Relationships any of these tables are included in then these relationships may need to be deleted first (after noting clearly how they're set up), and re-added afterwards.