[AccessD] Must see dbseechanges

John,

I was using the word Note as a field name once.  Access somehow wouldn't let
me use that in an INSERT INTO sql string.  I changed it to NoteX and it
worked fine.

Perhaps mdb. could be something else.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
Sent: Thursday, December 22, 2005 8:03 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Must see dbseechanges

I'm getting this error when opening a recordset using dao and a SQL Server
table:

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

I am using the following code:

    Set mrst = mdb.OpenRecordset(strsql, , dbSeeChanges)

Notice that I AM using dbSeeChanges.  These are ODBC linked tables in the
SQL Server database.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com