Update MS Access DB from VC(ADO)
-
How would i update an acces db from VC6,if the connectivity is done using ADO? Do i use an update query separately,or do i open the DB and then make changes? Detalied help would be really appreciated...thanks!
-
How would i update an acces db from VC6,if the connectivity is done using ADO? Do i use an update query separately,or do i open the DB and then make changes? Detalied help would be really appreciated...thanks!
hi, using the RecordSet Pointer of the ADO, and Call Open(...) method of the RecordSet. In the Open Metod of the RecordSet pass the String for the Update of the Command. like //========================================================== Connection.Open("\\....mdb"); RecordSet rs; rs.Open("Update table table name where value = " &value); rs.Close(...); //========================================================== cool. uday. uday kiran