• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 15. Going Beyond the Basics > Upgrading to Projects

Upgrading to Projects

A Microsoft Access project (identified in file lists with an .adp extension) is a new type of Access file that lets you use an Access interface for a Microsoft SQL Server database. You should create a project whenever you need to give experienced Access users the means to work with an SQL database. Rather than learn a new interface, your users can rely on their Access skills to work with the data in the SQL database.

An Access project only contains presentation-oriented or HTML-based database objects: forms, reports, pages, macros, and Visual Basic code modules. Unlike a Microsoft Access database, an Access project doesn't contain any data or data definition-based objects, that is, objects that derive their contents from data in your database, such as tables or queries. Those data-defined objects are maintained in the SQL Server database.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint