Hi Nathyx,

Basically you need to do the following:

1. Create a Data Connection to your Access database in Server Explorer (a.k.a. Database Explorer if you're using an Express version of Visual Studio).
2. Start the Data Source Configuration Wizard by clicking the 'Add New Data Source' command on theData menu.
3. Complete the wizard and then drag items from the Data Sources window onto the form.

Here are a couple help topics that show how to do this:

How to: Connect to Data in an Access Database

http://msdn2.microsoft.com/en-us/library/cf131f6b(VS.80).aspx

How to: Display Data on a Windows Form

http://msdn2.microsoft.com/en-us/library/wwh8ka92(VS.80).aspx

How to: Display Data from Related Tables

http://msdn2.microsoft.com/en-us/library/803kw7az(VS.80).aspx

Hope this helps...

Hello,

Can you provide any more details as to exactly what you are trying to accomplish?

Actually i am using a microsoft access, in which i have about 6 tables containing products of a company. All 6 tables are together in a single database. I want to use a single form to be able to add, update, delete data to each of the table. For example one of the tables is Nokia handphone and another Samsung handphone, i want to use a single form to add data such that if i type the name of the phone as in Nokia, the data will go to Nokia table like wise for samsung. Usint VB.NET

Thanks For your Interest

Hi Nathyx,

Basically you need to do the following:

1. Create a Data Connection to your Access database in Server Explorer (a.k.a. Database Explorer if you're using an Express version of Visual Studio).
2. Start the Data Source Configuration Wizard by clicking the 'Add New Data Source' command on theData menu.
3. Complete the wizard and then drag items from the Data Sources window onto the form.

Here are a couple help topics that show how to do this:

How to: Connect to Data in an Access Database

http://msdn2.microsoft.com/en-us/library/cf131f6b(VS.80).aspx

How to: Display Data on a Windows Form

http://msdn2.microsoft.com/en-us/library/wwh8ka92(VS.80).aspx

How to: Display Data from Related Tables

http://msdn2.microsoft.com/en-us/library/803kw7az(VS.80).aspx

Hope this helps...