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.

Ashby