Dan has attended:
Access Intermediate course
Backup/replica databases
if you replicate a database for a backup - will this run as a replica and always be updated at the same time as the master?
in other words if the database fails can the replica/backup be used with all current data saved to the point of failure?
RE: Backup/replica databases
Hi Dan,
To answer your question, the simple answer is no.
When a database is replicated, 2 copies of the database are created - a design master and a replica. These are two separate copies, and must be SYNCHRONISED for the data to be the same.
So if one copy of your database fails, then you would only have the latest synchronisation to go back to.
Regards
Richard
RE: Backup/replica databases
thankyou - is there a way to automate the Synchronisation?
i.e. twice a day automatically?
RE: Backup/replica databases
Hi Dan,
I had a look around the Access help and Macro menus.
You could probably build a routine using a combination of macros and VBA, although I am not skilled at that level of Access use.
I will reassign your question to the broader trainer group to see if anyone else has some ideas.
Regards
Richard
