>I want make a program to backup a database, can someone tell me how can i do this, the problem is that when the database is open i do not know how to zip it without closing the database
You can use XCOPY or similar first (while it is open), to copy it to another location. This even gives you the advantage that you can delete unwanted files (from the copy, of course).
The CAB format uses ca. 30% less disk space than the ZIP format (if the compression program handles it correctly).
My download #
10009 might give you some ideas.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)