Help...dbseechanges option error

[CJKCyclone]

I have an application with an Access 2002 front end linked to Access 2002 db. I am trying to convert the db side to SQL Server 2000. Everything appears to link up properly and I can run most everything with no problems....upon further testing I have gotten this error and I am stumped...

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

help?!?!

TIA

CJK

 

[CJKCyclone]

Put in the code for dbSeeChanges as described in another...

post and I am now getting "ODBC - Call failed"

ARGHH!