[RESOLVED] Access

[Lasering]

Hi!!

How do i from vb 2005 add a new record to a access DB and then save it?
(Sry my enlgish)

[nagasrikanth]

I think, You wanna to add a record in ACCESS Table using VB2005..If it is so,,

then build a recordset..

set rst=db.openrecordset(sql statement)

then add a new row to recordset using

rst.addnew

and then fill out all the required info in the new row like

rst(0)=xyz

and then update the new record using update method..ex:

rst.update

** This is what I used to do in VB6.0,I dont see VB2005 till now and so I dont know the correct syntaxes of it..If any one responded with correct syntaxes of 2005 then it will be greatly helpful 4 both of us..

All the best...

[Ecniv]

vb 2005 = .net (I think) - post in that forum.. The may have some simple tutorials to follow too.

[Lasering]

Thks guys!!