@echo off
"E:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE12\MSACCESS.EXE" "E:\Documents and Settings\All Users\Application Data\7T\IGSS32\V7.0\gss\dmyrep.mde" /CMD $-1 -l -hc:\HTMLrep\periodical\rep.html
FOR /F "TOKENS=1-3 DELIMS=- " %%A IN ('DATE /T') DO rename "rep.html" %%A%%B%%C.html

;INTRODUCTION
;This bat file is used for automatically generating an IGSS standard periodical report as a HTML file. It must be ;used in connection with the IGSS Job Scheduler program and will ensure daily generation and saving on disk of the ;report.
;You must have a full MS Access program installed or the Access Run Time version, which can be installed from the ;IGSS CD.
;You must edit the paths above to correspond to your own installation of Access and IGSS.
;EXPLANATION OF PARAMETERS
;1) The /CMD $-1 setting is a command line switch which requests periodical report generation from the data from ;the previous day. (Please refer to the Job Scheduler help file in the chapter called "Command Line Interface".)
;2) The -l setting requests a time period corresponding to local time. If this parameter is not used, the the time ;period will be UTC time.
;3) The setting -hc requests report generation as a HTML file (h) and requests that the report be saved to the C:\ ;drive (c) in the folder HTMLrep\peridical and with the name rep.html.
;4) The next line of settings is a DOS command requesting the the file name of the report be changed to the current ;date. In this way we avoid overwriting the the previously generated report with the newest one.
;5) Remember to rename this file to report.bat before using it.
;6) In the Job Sceduler program you only use the two following properties on the Action tab:
;a) Program path: (Insert the path to where this batch file is located on the hard disk.)
;b) Working foilder: (Insert the path to the folder on the hard disk where you want to store the generated HTML ;reports.
;7) Remeber to rename this file to report.bat before using it.
;8) To avoid seeing the opening of Access and the small window informing the user that the file is being generated, ;place a ; before the first line in this file.
;Best Regards, 7-Technologies A/S, Support Department, Denmark, www.7t.dk