How to: Create Connections to Access Databases
You connect your application to an Access database using the .NET Framework Provider for OleDB. For more information, see.
When connecting to data in local data files it is important to understand how the project system in Visual Studio manages these files. For more information, see.
Whether you are creating data connections with one of the data wizards or in Server Explorer/Database Explorer, the process of defining your connection is the same; you need to choose a data source in theand add connection information into the .
For a more complete example of connecting to an Access database, see.
The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see.
Connecting to an Access Database
To create a data connection to an Access database
In the Choose Data Source dialog box, select Microsoft Access Database File, and then click OK.
If the Add Connection dialog box opens, and the Data source is not Microsoft Access Database File, click Change to open the Choose/Change Data Source dialog box. For more information, see.
Enter the path to the database file you want to access, or click the Browse button to locate the database file.
Enter login information if required by your database. For more information, see.
Storing sensitive information (such as a password) can affect the security of your application. Using Windows Authentication (also known as integrated security) is a more secure way to control access to a database. For more information, see.