Working with Access Projects in Access 2007 - Creating an MS Access 2007 Project
(Page 2 of 4 )
In Access 2007 an Access project is created in a roundabout manner. The reason for this is not obvious. Click the Microsoft Office button and from the drop-down click on New.... This opens a number of options, none of which says Access project except for a canned project on the Microsoft web site. In the Blank Database form that opens at the bottom right, type in a suitable name such as the one shown here, Acc07Proj. Do not click on the Create button; instead, click on the Browse button and browse to any folder.
This opens the File New Database window with the name you typed in appearing in the File name's textbox. If you click OK it will not create a project. Click on the Save as type drop-down below File name, pick Microsoft Office Access Projects and then click OK.
This changes the Blank Database to New Project. Now click on the Create button.
This brings up the Microsoft Office Access message box. If you click on Yes, you will be connected to an existing SQL server database, and if you click on No, you can create a new database on one of the available servers. Here Yes is clicked to connect to an existing database.
This opens the Data Link Properties window where you need to select a server and provide other necessary information. Here you see three SQL servers: XPHTEK is a SQL 2000 Server; HodentekMYSORIAN is a SQL 2005 server on one machine; and Hodentek2/SQL Express is a SQL Express server on another networked machine.
The connection with one of the servers is made by providing the required Information, the authentication information and the database to which you require a connection as shown here. You can test the outcome of this information by hitting the Test Connection button. As you can see the three pieces of information provided on this window produced a successful connection. Here the provider tab is missing since it is an OLEDB provider, the native type for SQL servers.
Since Allow saving password was checked when you clicked on the OK button, you get the next informational message from MS Access.
Here the Save Password option was chosen and of course the message shows what will happen in this case. When the Save Password button is clicked it opens a window to the database objects.
Here a word about the Windy database is in order. Windy has only the tables from the Northwind database brought over to SQL Express using the Export/Import wizard on the SQL server HodentekMysorian. Hence you are seeing only the Tables. However as mentioned earlier you can create, modify, delete, and/or view database objects.
Next: Creating a Stored Procedure in the Project >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
/ 11 
