Creating Data Access Pages from Scratch - Connecting to the database
(Page 2 of 5 )
Click on the tab Data and in the window that pops up, click on the browse button (...) by the side of Connection File. This brings up the Select Data Source window dialogue as shown here.
This lists all the data source connections in the My Data Sources folder. Since the idea is to start from scratch, click on the button New Source... adjacent to the text box relevant to File Name:. This brings up the next picture as shown.
In this window the Microsoft SQL Server is chosen and the Next> button is clicked (You could also try the other option). This brings up the next window as shown here. The server name is typed in as shown. Here it is XPHTEK, the name of the SQL Server on this machine which can be accessed by using the Windows 2000 security log in for this machine.
On clicking Next>, the following window shows up where you need to choose the source of your data. The drop-down list should show all the databases on your server as shown.
The database pubs is chosen, and when this choice is made all the tables and views in this database are listed in this window as shown.
Clicking on Next> brings up a window that lets you save the connection with some description information, as well as saving some key words for searching at a future date, if needed. Clicking Finish will save the connection information to the My Data Sources folder.
As the connection is completed, it is now possible to get an idea of the fields available for the data access page. The field list can be accessed from the View menu item by choosing the Field List dropdown item as shown
This will populate and bring up the Field List as shown in this picture. The field list shows everything on the chosen database.
Next: Choosing the data >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
/ 21 
