Best Execute Options For Db.execute

Best execute options for db.execute

David Lloyd


I am not aware of a specific option of the Execute method that will allow
you to bypass the object exists error.

Best execute options for db.execute

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

This response is supplied "as is" without any representations or warranties.
"GSteven" <st***> wrote in message
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?


Nov 13 '05 #2

SSIS "Execute SQL Task" - single row result set to load into variables