How can u save a new record in the database in vb 6.0?

Question

i used adodb.connection and adodb.recordset for accessing the database (MS ACCESS) using vb and i use sql to find these records, im quite confused in making the transactions (save, add, edit, delete). before, i used the ado control to make a simple system, however the method of transactions here doesnt apply to the one im doing now, can anyone help me? ^_^

it says "current recordset does not support updating. This may be a limitation of the provider, or of the selected locktype"

Answer 1

Don't update the recordset....write a query that directly updates the table.

With your connection already open, just write a SQL statement like:

UPDATE PriceTable
SET Price = 6.00
WHERE Item = "Bananas"

Answer 2

To add to a table use the ADD command
To update records in the database, use the UPDATE command

Answer 3

hi you may save the path of the photos in mdb and all pictures in folder and restoration the image by using make link between the folder call/photograph call and the call of the document in mdb . i'm hoping help u