error 3219: invalid operation 
Author Message
 error 3219: invalid operation

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???

Sun, 07 Oct 2001 03:00:00 GMT  
 error 3219: invalid operation
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.

Mon, 08 Oct 2001 03:00:00 GMT  
 [ 2 post ] 

 Relevant Pages 

1. Run-Time Error '3219'

2. error 3219

3. Close causes 3219 error

4. Access Querries revisited and Error 3219

5. Runtime Error 3219 on Append?

6. SQL Error #3219

7. ADO error 3219

8. Run-time errors 3704 and 3219

9. Close causes 3219 error

10. Run-time error 3078 and 3219 (Problem with dbSqlPassThrough and FindFirst)

11. Error 3219 Can't perform ......

12. Wierd 3219 error


Powered by phpBB® Forum Software