vb ms access database connectivity

[Dee987]

hello,
i hav created a form in vb containing two fields ( roll no., name) and corressponding database table in access.
Kindly tell, how to connect, add, delete and update data.

[SanjuMtr]

hello,
i hav created a form in vb containing two fields ( roll no., name) and corressponding database table in access.
Kindly tell, how to connect, add, delete and update data.

ok buddy now I am giving u some hints.1st u try youself ,if requered i will give u the sample code.

1)add reference of ActiveX data objects 2.6.library
2)add connection object(ADODB)
3)set the connection string to the connection object.
4)add recordset .
recordset object is very powerfull.it will add,delete,update your records in database table.
try it first.