Hi there,
I'm currently attempting to automate the use of MS Access 2000's replication manager, but I don't have much knowledge in VBA. I am using Access 2010, but the two files I'm working with are saved as .mdb files (Access 2000). The first file is the data master (Example path is C:\MasterDB.mdb) while the other is a replica created from it. (C:\RepDB.mdb)
All I need to do is have either a VBA script or macro use the built-in replication manager from Access 2000, but I simply don't know how I would do this with VBA scripts. The replication manager is in a tab of the main menu under Database Tools --> Administer --> Replication Options --> Synchronize Now. When manually using the "Synchronize Now" option, I generally have the Master database synchronize with its replicated database.
The two files aren't located on the same computer, but are accessible via a network which both are permanently connected to.
Any advice on either the code or an alternative method to do this would be immensely helpful. Thanks!
I'm currently attempting to automate the use of MS Access 2000's replication manager, but I don't have much knowledge in VBA. I am using Access 2010, but the two files I'm working with are saved as .mdb files (Access 2000). The first file is the data master (Example path is C:\MasterDB.mdb) while the other is a replica created from it. (C:\RepDB.mdb)
All I need to do is have either a VBA script or macro use the built-in replication manager from Access 2000, but I simply don't know how I would do this with VBA scripts. The replication manager is in a tab of the main menu under Database Tools --> Administer --> Replication Options --> Synchronize Now. When manually using the "Synchronize Now" option, I generally have the Master database synchronize with its replicated database.
The two files aren't located on the same computer, but are accessible via a network which both are permanently connected to.
Any advice on either the code or an alternative method to do this would be immensely helpful. Thanks!
