Backup Question

[magster06]

Would it be ok just to make a copy of the BE file (every so often) rather than to make a copy via code?

The user can then just paste over the original if it becomes corrupt.

 

[Catalina]

That's how I do it, I copy the BE of all databases at least once a day.
I have that process automated through backup software.
And if there is extensive use, I do more often just to be on the safe side.

I keep may be 5 or 6 copies so I can go back a while if needed.
It is not unthinkable that wrong entries will cause a problem so I want to
be able to go back and check where and what went wrong. So it's not
just about corruption.

I haven't had a corrupt back end in many years, but if it should happen I can
just set the most recent one back.

I have never bothered to backup from within Access.

Catalina

 

[Lightwave]

Here's a thread where we discussed something similar specifically putting together a small vbs script which looks at automation much like Catalina's description. You could do it using a bat file as well.

VBS script to backup files

 

[magster06]

Thanks for the input guys!

 

[Catalina]

You're welcome.

Catalina