O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Access Projects

Microsoft developed Access projects for powerful and fast access from Access to SQL Server (or MSDE). Access projects use OLE DB and ADO. Figure 2-1 shows how Access and SQL Server work together.

Figure 2-1. Access and SQL Server

Tables, database diagrams, views, and stored procedures are stored on the server. Forms, reports, pages, macros, and modules, on the other hand, are saved in the Access project file (with the filename extension .adp).

In Access 2002, views and stored procedures have been combined under the generic term Queries, as shown in Figure 2-2. In addition, user-defined functions (UDFs), a new feature in SQL ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required