I have an access 2003 database.
I want a procedure written that so that on a click of a button the database can replicate itself. The code must also run under Access 2007 but the database must remain in Access 2003 format.
## Deliverables
The attached database in an Access 2003 database. It is not a replicated database at the moment.
It contains a form called frmStart. This form has a button called "Create Replica". I need code written behind this button that will do 2 things.
1. Flag the database and all the objects in it a replicable.
2. Create a replica of the database.
It is ok to for the standard warnings and prompts for the replica name to appear, but the user should not have to take any other action apart from answering these prompts. The user WILL NOT be required to take any other action.
The database MUST remain in 2003 format.
The database MUST work under Access 2007.