Hi. In the past I've made all of my changes in a copy of my production db and once it's working the way I want, I change the names on the existing object being changed and I copy objects over to the production db manually after hours. Any changes to the tables are duplicated manually so I make sure I don't affect the data. Generally it works but sometimes the production database gets hosed because maybe I forgot something on the transfer or some other detail and I end up restoring from a saved copy and trying to figure out what happened. There has to be an easier way though.
What is the best way to make multiple changes to an access database that may take days to fnish, without affecting data in a production environment?
Example - I have a database that has been running for years. I'm asked to include new report data that is not being tracked anywhere. I have to add fields to tables, change queries, forms, reports, afected macros, etc... What's the best way to do so so users don't see any lapse in functionality?