Using two options in Execute

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am converting an Access back end to SQL Server. Along the way I wanted to
add two options to an Execute statement. The second is to make it run under
SQL. Is it possible to have 2 options and what is the correct syntax

qdf.Execute dbFailOnError dbSeeChanges
 
qdf.Execute dbFailOnError dbSeeChanges
Click to expand...

dbFailOnError and dbSeeChanges are enumerated constants. They
represent numbers. Add them together - dbFailOnerror+dbSeeChanges

Put your editing cursor on .Execute and press F1 for more help.

HTH
Ananda
 
Thanks a lot Ananda. That did it. A useful piece of information that is not
obvious in the VBA help.

Neville
 
Back
Top