Redunancy

[DS]

Does anyone know how to set-up reduncy in Access. I want to have an up to
the minute back up in case the server goes down.
Thanks
DS

 

[Arvin Meyer [MVP]]

If the server is that unstable, you need a new one. If it's mission critical
that you cannot lose even an hour's data, you should consider using
SQL-Server for an engine instead of Jet. For Access to be backed up you can
write a simple batch file that runs ever hour (using the Windows scheduler).
You will need to kick everyone out because copying open files can lead to
data corruption. For a Kickem out routine, have a look at:

http://www.datastrat.com/Download/KickEm.zip

Instead of doing it manually, use a Timer event on a form to do it.

 

[John W. Vinson]

Does anyone know how to set-up reduncy in Access. I want to have an up to
the minute back up in case the server goes down.
Thanks
DS

Self-referenetial: a redundant post about redundancy! <g>

Answered in your other thread.

John W. Vinson [MVP]