ADO with DBF database

[Ologhai]

Hello all, thanks to help me.

i try to write in dbf database with ADO connection
i openned dbf database with AdOpenDynamic
AdLockOptimistic, etc

i'd try all options but always error when the time to update
the database.

thx. [sig][/sig]

 

[swilliams]

Can you paste in the code that you are using, and highlight the line that you are getting the error on??

Simon [sig][/sig]

 

[Ologhai]

gConnectionstring = "Provider=MSDASQL.1;DefaultDir=" _
& CurDir$ & ";Driver={Microsoft dBase Driver
(*.dbf)};DriverId=533;FIL=dBase III;"
Adodc1.ConnectionString = gConnectionstring
Adodc1.RecordSource = "SELECT " & fselect & " ORDER BY " &
forder
Adodc1.CursorType = adOpenDynamic
Adodc1.LockType = adLockOptimistic
Adodc1.Refresh

when i openned my database like this, I CAN'T update, write,delete etc.. i've got an error on .delete or .update
of my object [sig][/sig]