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

Creating Stored Procedures

A stored procedure can be created using the relevant designer from Access projects. In the Access 2000 Database window, select Stored Procedures and click New to open the Stored Procedure editor window shown in Figure 8-1.

Figure 8-1. New stored procedure

In Microsoft Access 2002 you can specify whether you want to create your stored procedure as text, as shown in Figure 8-1, or in a Design view similar to a view. If you select Queries in the Database window in Access 2002 and then select New, the New Query dialog box (see Figure 8-2) is displayed so that you can choose the variant you prefer. If you select Design ...

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