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



Special Edition Using Microsoft Office Access 2003
Special Edition Using Microsoft Office Access 2003
ISBN: 0789729520
EAN: 2147483647
Year: 2005
Pages: 417

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net