give some code on how to search, add,edit,delete if my extension name is .dbf i'am useing ADO
Printable View
give some code on how to search, add,edit,delete if my extension name is .dbf i'am useing ADO
You can do it the same way as it is an mdb file. The difference will be only in your connection string.
oConn.Open "Driver={Microsoft dBASE Driver (*.dbf)};" & _
"DriverID=277;" & _
"Dbq=\somepath;"
Note: Specify the filename in the SQL statement. For example:
oRs.Open "Select * From user.dbf", oConn, , ,adCmdText
Note: MDAC 2.1 (or greater) requires the Borland Database Engine (BDE) to update dBase DBF files.
(Q238431).
Iouri Boutchkine
[email protected]
oConn.Open "Driver={Microsoft dBASE Driver (*.dbf)};" & _
"DriverID=277;" & _
"Dbq=\somepath;"
Note: Specify the filename in the SQL statement. For example:
oRs.Open "Select * From user.dbf", oConn, , ,adCmdText
Note: MDAC 2.1 (or greater) requires the Borland Database Engine (BDE) to update dBase DBF files.
(Q238431).
I'tried to use this ..but failed..what am i missing
thanks
cyrus