exporting - overwriting existing snp. files

[Guest]

i am attempting to overwrite existing snp. files from an access database. I
receive a dialog box stating "file xyz.snp already exists, do you want to
replace the existing file?" There are "yes" and "no" buttons to select. I
would like these boxes to not appear and the file to automatically be
overwritten without the dialog box appearing. How can I do this?

 

[Rick Brandt]

i am attempting to overwrite existing snp. files from an access
database. I receive a dialog box stating "file xyz.snp already
exists, do you want to replace the existing file?" There are "yes"
and "no" buttons to select. I would like these boxes to not appear
and the file to automatically be overwritten without the dialog box
appearing. How can I do this?

You could just delete the file beforehand using Kill.

 

[Allen Browne]

Use Dir() to test if the file exists, and Kill to get rid of it.