Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training - Backup/replica databases

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

microsoft access training - Backup/replica databases

Resolved · Low Priority · Version Standard

Reply Tue 10 Jul 2007, 15:13Delegate Dan said...

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?

For upcoming training course dates see: Pricing & availability

Reply Mon 16 Jul 2007, 12:29Trainer Richard said...

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

Reply Wed 18 Jul 2007, 15:01Delegate Dan said...

RE: Backup/replica databases

thankyou - is there a way to automate the Synchronisation?
i.e. twice a day automatically?

Reply Thu 26 Jul 2007, 16:01Trainer Richard said...

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

Access articles

· How To Change The Data Displayed In A Linked Field In An Access Table
· Learn About Action Queries In Access
· How To Use Multiple Parameters In A Microsoft Access Query
· Access VBA Handling Errors and Debugging Code
· Share And Share Alike With Microsoft Access 2010

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips