dbSeeChangesOption

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.
 
M

Mark A. Sam

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
 
D

david epsom dot com dot au

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top