Backup for *.mdb

Guys, I have an mdb file for my application and I want user to make backup of this database on regular basis.

Can anyone help me by providing a code for how to save a copy of a file. I tried with CommonDialog but its not the way I want.

Thanks in advance

Just use the FileCopy method on the mdb

VB Code:

FileCopy "C:\my.mdb", "C:\backup.mdb"

May want to compress it first (less to copy).

Quote:

---

May want to compress it first (less to copy).

---

You want to compress it like winzip do ? well I think it will be hard to code, good luck.

I might go with Access Compact Database utitlity

It's not working, getting an error and I know why, it's because my application is using a same database file.

Any alternate way????

You mus close any active connection for the copy or the compaction (i did mean Access compression) to take place

I would recomend using the file copy API it will copy it even if it is in use.
I would recomend compacting the database on startup of the program.
If its a Multi user program, create a compact program to compact it on startup.