dbSeeChanges does not fix openrecordset error

[lringstad]

I have read all the threads about using the dbseechanges option on the openrecordset command but have not been able to get it to work under all situations.

my line that is erroring is

set rs = db.openrecordset(SQLSTMT, , dbseechanges)

table being accessed is a table linked to a SQL 2012 table with the identity column as the primary key.

table is
Field1
IdentityField
Field3


the first SQLSTMT was "Select * from Table where Field1 = " & variable1



even with the dbseechanges option I still get a 3622 error

then I tried "Select Field1,Field3 from table where Field1 = " & Variable1

this statement worked fine. and since I didn't need to have the value of the Identityfield I was good to go.

BUT I wanted to know how to do it if I needed the value of the Identify Column.

I tried "Select field1, indentityField, field3 from table where Field1 = " & Variable1

and once again I got the 3622 error.


Does anyone know how to make this work with the identify column.

thanks

[pbaldy]

What is the description for the 3622 error? The lack of capitalization in your code hints that Access isn't recognizing something. Mine looks like:

Set rs = db.OpenRecordset(strSql, dbOpenDynaset, dbSeeChanges)

How is rs declared?