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

The most common cause of this message is when Visual Basic cannot find a
unique index for the table.  This may happen when you actually do not have a
unique index, when the solution is to add one (an Informix serial field, if
nothing else, will do the trick).  

It may also happen when the primary index is created as a constraint rather
than an actual index; the SQL used by some ODBC drivers to figure out
whether there is a unique index frequently does not take constraints into
account.
-----
William Harris