Printable View
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?
- 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?
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?
This one possibility from ttniep might indeed be the case:
Quote:
The Recordset object was either created from multiple tables without a JOIN statement or the query was too complex.