I am backing up a database at the end of each day and want to accumulate the backups - not overwrite the current database with the new one. The database name is OFFICE.mdb.
However, the overwrite is still operating and I do not get my accumulation . Office.mdb, Office_1.mdb, Office_2.mdb etc... (Note, I do not need to have the identifiers _1, _2 etc - any identifier which coldfusion wishes to use would be fine.)
I am using coldfusion 8 developer edition with windows XP.
Have attached the code.
Many thanks for any help
<cffile action = "copy" nameconflict="MAKEUNIQUE"
source = "C:\ColdFusion8\wwwroot\office_11\database\office.mdb"
destination = "G:\DATABASE_BACKUP\"