Software

Ask something
Discussion Locked

adding a record to a access db in vb

0 helpful
1 reply

by simon_hawkins2000

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to add a new record to an access db using vb but every time i try it goes to overwrite a record, i am using data.recordset.addnew and then data.recordset.update but this isnt working. The only way i can add a new record is by closing andthen opening the program.
Please can someone help me!
Cheers in advance
Simon

1 reply

by aaron_kempf

if i were you and i would ADO to execute an Insert SQL Statement.

its not that difficult-- maybe 4 lines of code something.

This discussion is closed to new replies.