In this exercise, you will establish connectivity to a new Microsoft Access database, creating a Database Instance, Database Connection, and Database Login:
You will need Microsoft Access installed to create a new database.
- Create a new Microsoft Access database. Add a dummy table. Name both the database and the table Chapter7.
If you don't know how to create a MS Access database, simply right-click on the Data Explorer in the machine where it is installed | New | Microsoft Access Database.
- For this exercise, we will use an MS Access 2000 file with the *.mdb. If your machine has an MS Access driver for .accdb, you can use such a file. We will learn in the following step how to add a DSN ...