update ms access data from vb6
hi
I have created a program to connect to a Access database and retrieve records from it using a recordset.
I am using the ADOBC.Recordset sort of connection.
I know how to add records, delete records however i dont know how to edit already existing records.
say i have a column called "STATUS" in the access table. when i click the command button i need to edit the value of the 5th row of the STATUS column to 3.
Anyhepls help me anyone
hi
I have created a program to connect to a Access database and retrieve records from it using a recordset.
I am using the ADOBC.Recordset sort of connection.
I know how to add records, delete records however i dont know how to edit already existing records.
say i have a column called "STATUS" in the access table. when i click the command button i need to edit the value of the 5th row of the STATUS column to 3.
Anyhepls help me anyone