dbSeeChanges

[swagger18]

Good morning all,



I have a form which acts as a search form to find records within the database.

The database was created in access but has since had the table upsized to SQL 2005. The Search Form was working but now I get the following error displayed.

You must see the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column.

The debugger takes me the the following lines of code.

Set db = CurrentDb
Set rcd = db.OpenRecordset("select " & _
"IT_SupportTable.LogNumber " & _
"FROM IT_SupportTable" & _
" WHERE " & strWhere & ";")

Can anyone help me with where I should be putting the dbSeeChanges.

Many thanks,

[RuralGuy]

Is this Solved? If so, do you care to share your solution with others that read this forum?

[swagger18]

Is this Solved? If so, do you care to share your solution with others that read this forum?

Certainly sir,

Set rcd = db.OpenRecordset("select " & _
"IT_SupportTable.LogNumber " & _
"FROM IT_SupportTable" & _
" WHERE " & strWhere & ";",dbOpenDynaset, dbSeeChanges)

Got the answer from another forum that I am apart of.

[RuralGuy]

Thank you.