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

Chapter 12. Developing an ADP Application > What Are Access Projects?

What Are Access Projects?

Access 2000 introduced Access Projects (ADP). Whereas an Access database uses the Jet Engine and Open Database Connectivity (ODBC) to access client/server data, ADPs use OLE DB to access client/server data. This provides you with greatly enhanced functionality and performance when dealing with client/server data. The only caveat is that the client/server data must be stored in a Microsoft SQL Server 2000 database, a Microsoft SQL Server 7.0 database, the Microsoft Data Engine (MSDE) file format, or a Microsoft SQL Server 6.5 database with Service Pack 5 installed.

If you use an Access database to access client/server data, you must use linked tables, SQL pass-through queries, and ActiveX data object (ADO) code to manipulate the data. If you want to modify the structures of the client/server tables, you must do so within the SQL Server environment. With an Access Project, you can create and modify tables, views, database diagrams, and stored procedures directly from the Access environment.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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