Updating table data/macros/etc

[Guest]

If I enhance an Access 2000 db by changing VBA code for and event, how can
get export the code from UpdatedDB to OldDB. What I am trying to do is if I
make enhancements, update an older copy with all the new forms, code, etc.

Thanks

 

[Rick Brandt]

If I enhance an Access 2000 db by changing VBA code for and event,
how can get export the code from UpdatedDB to OldDB. What I am trying
to do is if I make enhancements, update an older copy with all the
new forms, code, etc.

Thanks

The preferred method is to split your app into two files. One with just the
tables and one with everyting else. Then you can just replace the "front end"
file entirely with a revised one without affecting the data.

 

[Guest]

Thank you...

I know that if you change locations of the database files the links no
longer exist. How do you identify the current db location and establish the
links between the tables if the location is different than where the link was
originally created? And at what point in the loading of the database would
that code be processed?

Thanks again. Once I saw the answer to my first question, it was obvious..