Using two options in Execute

[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

 

[Jeff Boyce]

Neville

Have you checked Access HELP for the correct syntax for the Execute
statement?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[AnandaSim]

qdf.Execute dbFailOnError dbSeeChanges

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

 

[Guest]

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

Neville