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