exporting - overwriting existing snp. files

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?

smagala29 wrote:
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.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"smagala29" wrote in message
...
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?