How to create Mirror Database for MS ACCESS Database

[tom2013]

Hi,

Can anyone please help to setup following

1) How to create a Mirror database for Microsoft Access Database.

2) How to synchronize mirrored MS ACCESS databases.

Thanks in advance,
Tom

[zmbd]

Understanding why you need this would be helpfull in choosing the correct path.

[neelsfer]

i am also looking forward to the comments on this topic, as i also need to do it in case of DB corruption one day.

[zmbd]

As Op hasn't shown any further interest I'll put this to bed:

Mirroring for MS Access Databases:
This is something that is native to most "Mature" databases such as SQLSrvr ( Database Mirroring SQL Server 2008 R2); however, there is no such easy, built in means for MS Access.

One workaround for this would be to use two connection strings one to say "main.accb" and the the second connection string to "mirror.acc b". I'd more than likely use different workspaces ( Workspace Object (DAO) Office 2010 )
Now anything done in one workspace is duplicated in the second workspace. You could use a simple SHA/SHA2 digest on open/close of the front end to verify the files are the same. You're out of sync then you'd have to open the DB up and run a few (dozens) of queries to find the missing/duplicated records between the two mirrored DB.
Those would be, IMHO, the easiest steps; however, not something I’m personally interested in implementing.

If however, OP is looking for the basic data-backup then I recommend splitting the database and then using DBEngine.Compac tDatabase strData, strBkp to compact and backup the backend and I have a small code loop that deletes oldest backup of three and then saves a copy of the backend to “strBkp”