dbSeeChangesOption

  • Thread starter Thread starter Mark A. Sam
  • Start date Start date
M

Mark A. Sam

Does anyone know what the dbSeeChangesOption referrs to? I received an
error message,

You must us the dbSeeChanges option with recordset when accessing a SQL
Server table that has an IDENTITY COLUMN.

It occured while executing this line in the code:

Set rsProdMats = dbs.OpenRecordset("Order Entry ST Materials",
dbOpenDynaset)

The procedure was written for an Access backend. I am working out issues of
moving the tables to SQL SERVER 2000 with Service Pack SP3a.

God Bless,

Mark A. Sam


Thanks for any help.
 
I see that dcSeeChanges is an option to the OpenRecordSet method, but am not
sure what it does and haven't identified when it is needed. I have several
OpenRecordSet methods in a the procedure, but they don't all generate the
error.

God Bless,

Mark A. Sam
 
Snapshots don't need it. Simple Append queries don't need it. Queries that
only reference local tables don't need it. Update, Append, Dynaset queries
that read data from a SQL Server table do need it.

(david)
 
Back
Top