Recordset not updatable 
Author Message
 Recordset not updatable

We are using Access 97 to connect via ODBCDirect to a SQL Server 6.5
Database. I can retrieve records fine, but when I try to update a
recordset, it says the recordset is read-only. I know that the
Connection is updatable.

My OpenRecordset is this:
Set rstBasic = conBasic.OpenRecordset(szSql, dbOpenDynamic)

When I try to add other options or lock options, I get invalid argument
errors. This is frustrating. The permission on the SQL Server are
correct, if I link the table I can update it.

Please respond via the newsgroup and e-mail. Thanks.


Sun, 30 Dec 2001 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Q: Recordset not updatable !

2. recordset not updatable

3. SQL Server JOINed recordsets not updatable?

4. Why is my recordset not updatable?

5. Command-based ADO recordset NOT UPDATABLE????

6. Recordset not updatable after call Stored Procedure

7. Recordset not updatable (VB6/Access97)

8. Why are ODBCDirect recordsets not updatable?

9. WHY? Inner Join Recordset not Updatable?

10. recordset updatable for me, but not for other users

11. Updatable property in ADO recordset -- It's not there

12. Recordset is not updatable - why?


Powered by phpBB® Forum Software