How to Connect Microsoft Visual Studio(VB.NET) with MS-ACCESS.

1. Make sure that you have Access 2007 or later installed.

2. Start Visual Studio, and then create a new Visual Basic Windows Forms Application Project

3. On the Data menu, click the Add New Data Source command.

4. Click the Database icon (if it is not already selected) in the Data Source Configuration Wizard, and then click Next.

5. Click Dataset, and then click Next to select the dataset model.

6. Click the New Connection button.

7. Click Microsoft Access Database File, and then click Continue (or OK).

8. Click Browse.

The Select Microsoft Access Database File dialog box opens, which functions like an Open dialog box.

9. Browse to the folder, click the Your_Project.accdb database,

and then input your name and password, and then click Open.

10. Click the Test Connection button.

11. Click OK to close the message box, and then click OK to close the Add Connection dialog box.

12. Click the plus sign (+) next to the Connection String item in the dialog box to display your completed connection string.

13. Click the Next button.

14. Click No to avoid making an extra copy of the database at this time.

You are not commercially distributing this project; it is only a sample program, and an extra copy is not needed.

15. Click Next to save the default connection string.

Thank you.