CJKCyclone
New member
- Local time
- Today, 02:02
- Joined
- Nov 13, 2002
- Messages
- 7
Background - Access 2k2 front end and backend application....Transferred the backend to SQL Server 2K.
Getting error that
"You must use DBSeeChangesoption with OpenRecordset when accessing a SQL Server table that has IDENTITY column"
When I do this...my code looks like this:
Dim db As Database
Dim rs As Recordset
Dim Msg, Style, Title, titlei, default, myvalue, message, Response,MyString, x, y
Set db = CurrentDb
Set rs = db.OpenRecordset("History", dbOpenDynaset, dbSeeChanges)
When I run it
I get "ODBC - call failed" now instead of previous message
Ideas? Advice? What am I missing?
TIA!
Getting error that
"You must use DBSeeChangesoption with OpenRecordset when accessing a SQL Server table that has IDENTITY column"
When I do this...my code looks like this:
Dim db As Database
Dim rs As Recordset
Dim Msg, Style, Title, titlei, default, myvalue, message, Response,MyString, x, y
Set db = CurrentDb
Set rs = db.OpenRecordset("History", dbOpenDynaset, dbSeeChanges)
When I run it
I get "ODBC - call failed" now instead of previous message
Ideas? Advice? What am I missing?
TIA!
