514 Part IV Database and Web Programming
- Click the Access Database icon, type Faculty2010 in the Specify An ID For The Data
Source box, and then click OK.
You are now prompted to specify the location of the Access database on your system.
(This dialog box is slightly different than the one you used in Chapter 18 .) - Type C:\Vb10sbs\Chap18\Faculty2010.accdb, and then click Next.
Note If you get a message that says “The Microsoft .ACE .OLEDB .12 .0 provider is not
registered on the local machine,” you might not have Access 2007 or later installed. If you
don’t have Access 2007 or later installed, you will need to download and install the 2007
Office System Driver: Data Connectivity Components from Microsoft .com.You are now asked to configure your data source; that is, to select the table and fields
that you want to display on your Web page. Here, you’ll use two fields from the Faculty
table. (Remember that in Visual Studio, database fields are often referred to as columns,
so you’ll see the word columns used in the IDE and the following instructions .)- Click the Name list box arrow, and then click Faculty. (There is probably only one or two
database tables here, but if there are several, click the Name arrow to view them .) - Select the Last Name and Business Phone check boxes in the Columns list box.
Your screen looks like this: