Combining Openrecordset RecordsetOptionEnum Options

[dbowman1970]

How are RecordsetOptionEnum options combined in an DAO Openrecordset statement.
For example db.openrecordset( strsql, dbOpenDynaset, dbseechanges and dbinconsistent). I need both of the last 2 options since I am connecting to a sql server and the query structure needs the inconsistent parameter.



Thanks in advance.

[CJ_London]

not tried, but normally you just add them

dbOpenDynaset+dbseechanges+dbinconsistent

ensuring you don't have any which are mutually exclusive

if you see this link

https://msdn.microsoft.com/en-us/lib.../ff192649.aspx

you'll see the numbers are a square progression so it is not possible to add combinations to the same value

[dbowman1970]

Thanks Ajax this seems to have solved the question since the recordset was created without errors.