How can i connect access database to vb.net

[Charbz]

Hey guys i am new to this site so if i make any mistake i appoligise. My problem is that im trying to connect an access database to my program in vb.net using VS2005. What im trying to do is update the database and let it show in my form1 without actualy opening the access sheet like for instance if i wona add to the database first name, last name, date of birth etc... i wona be able to see it in my form one and press an edit or add button if i want to change and add or delete straight from my program to the database and i would like the database to show in a list box or textbox with multiline it doesnt matter.

[Jordan]

You can add the DB as a datasource in VB. This will allow you full access.

Posted via CodeCall Mobile

[Charbz]

Hi Jordan and thanks for your quick reply... I really need some help i got a project in college to create a video rental program and im stuck on creating the rules form for it. wat i would like to achieve is create the rules in MS-Access which i already done that got 11 tables and 7 fields each field contains a different day of the week and the last table is the activate table with a check box to activate the rules on each field. Now in vb.net i wona be able to add, edit or delete these rules and i wona be able to view them and i gotta create a help file which explains how to use this rule form ... i hope i explained myself clearly and i really hope people on this site wil be able to help me thanks.

[Technosurfer]

Hi Jordan, please receive thanks from me too.
Your tip is helping me a lot.

[Xav]

You can use System.Data.OLEDB, with all the relevant classes. Remember, Access uses Microsoft Jet OLEDB to connect.