Chapter 20. Exploring Access Data Projects and SQL Server 2000
In this chapter
Moving Access to the Client/Server Model
Understanding the Role of SQL Server and ADP
Getting Acquainted with Access Data Projects
Working with SQL Server Tables in the Project Designer
Exploring SQL Server Views
Taking Advantage of In-line Functions
Examining Stored Procedures
Diagramming Table Relationships
Backing Up and Restoring Databases
Transferring the Project’s Database to a Server
Connecting to a Remote SQL Server Database
Linking Remote Servers
Securing Your Project as an .ade File
Troubleshooting
In the Real World—Strategic Database Schizophrenia
Moving Access to the Client/Server Model
Access 2003’s Access data projects (ADP), also called Microsoft Access projects or Access ...
Get Special Edition Using Microsoft® Office Access 2003 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
