How to backup Access file using VBA code and zip it
Hi, it's been a lot of time since last post. i have found this nice access file that is very useful if you have an access database file that is separated from the original main file, it's mean like this scenario: you have the main program that is an access file (*.mdb or *.mde) (like main.mde) that contains all the forms and the reports and the modules.. and you have a separate file mdb or mde also (like data.mdb) that contains the tables and the data.. in this way you can't make a backup of the data file using backup database tool located in the access software... you need to backup the data.mdb file... so how you do this!!! using the modules located in this file " backup demo " you can easily do this.. just click the button and the program will check if you have installed Winzip... if you did it will backup the file to a temporary folder and zip it than save it in the location you want.. else it will just copy the file to the location you...