dbSeeChanges Error ??

I'm running Access 97 and am in the process of converting my tables to SQL Server 2000. My project has a few forms, and in one form, I had no problems opening a table with the following:

Set dbs = CurrentDb
Set rst1 = dbs.OpenRecordset("dbo_tblNonSap")

However, since I've converted to SQL Server, I now get the following error:

"You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column."

I've tried modifying the dbs.OpenRecordSet line to

Set rst1 = dbs.OpenRecordset("dbo_tblNonSap",,dbSeeChanges)

but that does not help.

Any comments or suggestions are most appreciated -- My head hurts from pulling out too many hairs!

Set rst1 = db.OpenRecordset("dbo_tblNonSap", dbOpenDynaset, [dbSeeChanges])

Thanks for your reply...... that did the trick!

You're Welcome