AddNew problem

[koma]

I get the following error message when I try to run the AddNew method of a DAO recordset:
Object or Database is read only.

The database is accessed over ODBC to a SQL 7.0 server.

The same code works fine with a ODBC connection to a SQL 6.5 server.

What can I try?

[pardede]

- Did you open the recordset using the right properties (snapshot/dynaset/...)?

- Check whether the database itself IS read-only

- Any password protection on the DB?

[koma]

Hi and thanks for your answer.

The recordset is an DAO recordset of dynaset type. The database is not opened as read only.

The strange thing is that I can delete or insert records using SQL pass-through (or using ISQL) but I keep getting that error message when I try to use the AddNew method.

Could it possibly be that SQL Server 7.0 does not support DAO? Or does it?

[pardede]

This one possibility from ttniep might indeed be the case:
The Recordset object was either created from multiple tables without a JOIN statement or the query was too complex.