FileCopy

[Guest]

Hello

I've create a small autoexec macro that automatically copy a database so as to create a daily backup. In the routine it also verifies the file creation dates and deletes backup that are more than 7 days old

Here's the problem, the code uses the filecopy function and with this function all the files retain the original files creation date and not the date when the backup occured (as would be the case if I performed a copy paste of the file)

what alternative method, instead of filecopy, can I use so that the backup is given the appropriate creation date

Thank you (as always!!!)

Daniel

 

[Roger Carlson]

Try using the Compact Database method instead. You compact it into new name
(perhaps by adding the date to the name). On my website (see sig below) is
a small sample database called "CompactDatabase.mdb" which demonstrates how.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Hello,

I've create a small autoexec macro that automatically copy a database so

as to create a daily backup. In the routine it also verifies the file
creation dates and deletes backup that are more than 7 days old.

Here's the problem, the code uses the filecopy function and with this

function all the files retain the original files creation date and not the
date when the backup occured (as would be the case if I performed a copy
paste of the file).

what alternative method, instead of filecopy, can I use so that the backup

is given the appropriate creation date?