We'll need to specify a database name in this window, and we're going to
select a sample database that Microsoft ships with both Access and Visual
Basic called BIBLIO.MDB (it contains data about books, authors, publishers
and titles). For Access Databases, the User Name is 'Admin' by default, and
there is no password. If we had selected an Oracle or SQL Server Provider,
this window would look somewhat different, but the idea is the same. For now,
let's find and select the BIBLIO.Mdb database using this window…then click on the Open button…
As you can see, the name of the Database now appears on the Connection
Tab. At this point, we've established the parameters for the Connection. It's a
good idea to click on the Test Connection button to ensure that the parameters
are correct, and that the Database can be opened. A few seconds later, this
window should appear…
After clicking on this Message Box, you'll be back at this window…
Click on the OK button, and you'll be back here…