[AccessD] Must see dbseechanges

Have you tried specifying the recordset type (even thought it's supposed to
default to dbOpenDynaset)?

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


-----Original Message-----
From: John Colby [mailto:jwcolby at colbyconsulting.com]
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

**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************