Eric,

I created a standard exe project then I created a connection( ODBC to an Access database) in the dataenvironment of my main form. Then I created a command ( source is a table called DDA1 from an Access database). Then I drag couple of fields to my main form and I added a command button to advance to the next records :

Private Sub cmdNext_Click()
deEUC.rscmDDA1.MoveNext
End Sub

Then I added the following code to other command button :

Private Sub cmdUpdate_Click()
MsgBox deEUC.rscmDDA1.Fields("account_balance").Value
Do While Not deEUC.rscmDDA1.EOF

If deEUC.rscmDDA1.Fields("account_balance").Value > 50000 Then
deEUC.rscmDDA1.Fields("positive_negative").Value = "Positive"
End If
deEUC.rscmDDA1.MoveNext
Loop
End Sub

I run the form and I get the following error when I click on the cmdUpdate command button:

"Run-time error '3251'
The operation requested by the application is not supported by the provider"

I'm stuck!!!!!!


Thanks,
Sergio