Use dbseechanges option with openrecordset

[spleewars]

I've migrated the whole database to SQL server and i got popup up with this error:

"error 3622 you must use the dbseechanges option with openrecordset when accessing a sql server table that has an identity column"



Debugging the issue is directing me to this line:

Set rst = CurrentDb.OpenRecordset("Select * from registrygz")

any guideline?

[pbaldy]

This type of thing:

Set rst = CurrentDb.OpenRecordset("Select * from registrygz", dbOpenDynaset, dbSeeChanges)

[spleewars]

This type of thing:

Set rst = CurrentDb.OpenRecordset("Select * from registrygz", dbOpenDynaset, dbSeeChanges)

Big thanks for your help once again

[pbaldy]

No problemo!