Merge Two Access Databases
-
I'm not sure if this is the best place to post this, but I thought I'd try here since it's not towards a specific language. I am developing a desktop application that is using a MS Access 2000 database file as the backend. I have my application out to someone who is testing it for me therefore they are adding information to the database. Meanwhile, I'm developing and adding fields and tables. When I decide to send them a new version, I have to manually take their information and move it over to my new database structure. I would like to somehow find a tool that would allow me to merge the information and the new fields would just be empty or a 0 if a number. Any ideas on this? Thanks, Jonathan
-
I'm not sure if this is the best place to post this, but I thought I'd try here since it's not towards a specific language. I am developing a desktop application that is using a MS Access 2000 database file as the backend. I have my application out to someone who is testing it for me therefore they are adding information to the database. Meanwhile, I'm developing and adding fields and tables. When I decide to send them a new version, I have to manually take their information and move it over to my new database structure. I would like to somehow find a tool that would allow me to merge the information and the new fields would just be empty or a 0 if a number. Any ideas on this? Thanks, Jonathan