cravincreeks
Technical User
Hello all,
I'm working on a VBA-ADO programming project to merge three database tables into one. All of the incoming datasets will likely be manually imported into Access before any code is executed. I'm going to have to pre-process each of the three datasets, including GIS processing where the only options for writing is writing into an Access database. But I'm seriously considering backing up or replicating our data into a MySQL database - I don't like relying on Access alone since it's backup system doesn't allow a point-in-time recovery (am I correct here? no transaction log = no detailed data recovery - barring back up copies of the .mdb file?). So near the end of my program, I want to initiate a synchronization/replication with/to the MySQL database.
More considerations: Existing records in both databases may be updated by other users- the synchronization must account for this. Also, database users may delete one or more records from either database - the synchronization must also account for this. Finally, other users might insert records into either database.
In a nutshell, is there any freely-accessible, COM-compliant code/objectclasses/methods out there for synchronizing tables in two different databases (including different rdbms - probably working through ODBC connections).
Thanks
AZ
I'm working on a VBA-ADO programming project to merge three database tables into one. All of the incoming datasets will likely be manually imported into Access before any code is executed. I'm going to have to pre-process each of the three datasets, including GIS processing where the only options for writing is writing into an Access database. But I'm seriously considering backing up or replicating our data into a MySQL database - I don't like relying on Access alone since it's backup system doesn't allow a point-in-time recovery (am I correct here? no transaction log = no detailed data recovery - barring back up copies of the .mdb file?). So near the end of my program, I want to initiate a synchronization/replication with/to the MySQL database.
More considerations: Existing records in both databases may be updated by other users- the synchronization must account for this. Also, database users may delete one or more records from either database - the synchronization must also account for this. Finally, other users might insert records into either database.
In a nutshell, is there any freely-accessible, COM-compliant code/objectclasses/methods out there for synchronizing tables in two different databases (including different rdbms - probably working through ODBC connections).
Thanks
AZ