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

Chapter 2. The Many Faces of Microsoft A... > Exploring a Project File—LawTrack Co...

Exploring a Project File—LawTrack Contacts

Microsoft Access 2000 introduced an advanced facility that allows you to create a project file (with an .adp extension) that contains only your forms, reports, data access pages, macros, and modules. When you create a new project file, you can specify a Microsoft SQL Server database to support the project. SQL Server stores the tables and queries that you use in the application that you design in the project. You can connect your project file to a Microsoft SQL Server version 6.5 database on a server or to a version 7.0 or later database on a server or on your desktop. Included with Microsoft Office 2003 is a special edition of SQL Server 2000, the Microsoft SQL Server Desktop Engine (MSDE), that you can install to run on your desktop computer. An Access project file is ideal for designing mission-critical applications or applications that need to support dozens of users. SQL Server provides more robust data integrity and data sharing features than a desktop database.

You will see available tables in the server database as table objects in your project. You will also see views, functions, and stored procedures as query objects. Access 2003 includes special table and query editors to allow you to work directly with the objects in SQL Server. Your project file also contains forms, reports, macros, and modules that are virtually identical to those you develop in a desktop database (.mdb).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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