i've a problem when i want update a record in Dbase IV database.
i use [ODBC Visual Fox Pro Driver]

wSQL = "SELECT * FROM app"
recDBF.Open wSQL, ConDBF, adOpenDynamic, adLockOptimistic
recDBF!DERN_MANUF = wDern_Manuf
recDBF.Update  <------Error access violation
recDBF.Close

thanks to help me

I tried it here using Dynamic and also Keyset and i get a message from ADO
saying that it thinks the database is read-only. It is not of course. I
would think that we need to open the DBF folder with some parameters that we
are missing.

The rs.Supports method says that Update is a supported action, so we must be
doing something wrong.when opening the database. The sample using Update in
the help used a Keyset type and Optimistic locking.
--
Russ E. R.
DMCI-modis
Director, Software Development