Working with Access Projects in Access 2007
(Page 1 of 4 )
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.
Introduction
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.
Next: Creating an MS Access 2007 Project >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
/ 21 
