Working with Access Projects in Access 2007

Working with Access Projects in Access 2007 Hot

Tag it:

Articles Reviews Microsoft Access

Written by Jayaram Krishnaswamy

Thursday, 22 March 2007

{mos_sb_discuss:25}

Microsoft Access 2007 features significant differences from earlier versions. One of these is the lack of support for data access pages. Projects become important in this environment.

This tutorial will show you how to create an Access project and more.

Microsoft Access projects are based on a file with the adp extension. They provide efficient native mode access to SQL servers through an OLEDB interface. In the earlier versions you could have created web-based applications using data access pages as well as client/server type applications using forms/reports. Access 2007 does not have data access pages but supports Access projects.

Projects can use only SQL databases (desktop version or otherwise) on a local machine or on a networked machine. You can also work with projects created in earlier versions of MS Access.

Access projects are better than just linking to tables in the database.

Links can only be made to tables or views and you cannot change the table structure or change the design of the table used in creating the view.

On the contrary, in Access projects you can make changes or even create new objects on the database. The database objects are stored on the SQL server, however you have the support of tools such as table designer and a query designer as well as a SQL text editor that can be used to make changes. You can modify, create, delete or display any database object.

In this tutorial you will learn how to create an Access project and create and execute a stored procedure.

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.

Read more

User reviews

There are no user reviews for this item.

Add new review

Last Updated ( Thursday, 05 July 2007 )

< Prev		Next >

[ Back ]