I am trying to edit a field in an ODBC data source using Informix CLI 2.5
from a snippet of code written in Visual Basic 5.0.  The problem I am
running into is that every attempt I make to insert, or edit a field, I
receive an error that the database is read-only.  I do know I have insert &
edit  permissions with this user, as I can manually make changes from within
MS Access 97 using the same ODBC datasource and user name.  Any ideas?

Sub newpassword(password As String)
    Dim trend As Database, trend_member_key As Recordset

    informix$ = "ODBC;DSN=maestro;UID=user1;PWD=user;DATABASE=trend;"

    Set trend = Workspaces(0).OpenDatabase("", False, False, informix$)
    Set trend_member_key = trend.OpenRecordset("select * from member where
loginname='JOHN DOE';", dbOpenDynaset)
    trend_member_key.MoveLast
    trend_member_key.MoveFirst

    trend_member_key.Edit
    trend_member_key![password] = password
    trend_member_key.Update
    trend_member_key.Close
    trend.Close
End Sub

Jason Bramble