[AccessD] Must see dbseechanges

John Colby jwcolby at ColbyConsulting.com
Thu Dec 22 08:03:27 CST 2005


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/




More information about the AccessD mailing list