ADO error

Candice
12-19-2000, 08:32 PM
Hi
I create a project with VB 6.0 and use ADO object to access *.DBF(DB III)
But it can read only, can't write

example :
driver = "{Microsoft dBase Driver (*.dbf)}"
str1 = "DRIVER=" & driver & ";DBQ=c:\" &
dbf_cnn.Open str1
Set recTarp = New ADODB.Recordset
recTarp.Open "SELECT * FROM list " , dbf_cnn, 1,3

recTarp.Addnew
recTarp!AA ="PP"
recTarp.Update ===> error read only

Who can give me solution
Thanks

whelanp
12-20-2000, 02:14 AM
This could be due to a number of issues:

The recordset Type . Not sure what the values 1 & 3 are (the constants are there for a reason) make sure you've not opened a static type recordset.

The MS DBF driver is (and always has been) crap. I have come across situations with DBF type files that just will not update using the MS drivers.

Not very good responce, but may help.

re-post if and when you find a solution.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum