By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,968 Members | 1,871 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,968 IT Pros & Developers. It's quick & easy.

CurrentDb.Execute options

P: n/a
I have a statemnt which says:
CurrentDb.Execute strSQL, dbFailOnError

where strSQL is a create query. Is there an overwrite option for the execute
method so thath I don't get the 'file already exists' error?

tia
Steve
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Steve:

I am not aware of a specific option of the Execute method that will allow
you to bypass the object exists error. One approach would be to check for
the existence of the object prior to calling the Execute method and deleting
the object if it exists.
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"GSteven" <st***@s1f-w1yr5cycl5r.com> wrote in message
news:d8**********@news3.infoave.net...
I have a statemnt which says:
CurrentDb.Execute strSQL, dbFailOnError

where strSQL is a create query. Is there an overwrite option for the execute
method so thath I don't get the 'file already exists' error?

tia
Steve

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.