Hi all.
In Access97 I get this error when attempting to use VBA to do a .addnew.
This is something that I do all the time and works fine on tables that were
converted to SQL from Acc97. Now after I have created a new table using
either the SQL enterprise manager or the VB or Interdev IDE this error will
occur if I try to .addnew to a dynaset based on a query. Oddly enough if I
base a form on a query, I can add records. If I run the query I can add
records. If I base the dynaset on the table, I can use .addnew. The
combination of cbf, query dynaset, and .addnew fails on every new
table/query combo. I can paste the following into the debug window and get
the following results:

set rs = db.openrecordset("qryNew", DB_OPEN_DYNASET, DBSEECHANGES)
rs.addnew            ERROR 3219

set rs = db.openrecordset("qryOld", DB_OPEN_DYNASET, DBSEECHANGES)
rs.addnew            no problem

set rs = db.openrecordset("tblNew", DB_OPEN_DYNASET, DBSEECHANGES)
rs.addnew            no problem

Any clues???
arm

Never mind!
I found the problem. On the query properties page, if the "unique records"
is set to true, then .addnew is not a valid operation.
arm