Working with Stored Procedures in an MS Access Project - Creating a Stored Procedure
(Page 2 of 4 )
Under Objects in the Project click on Queries. This shows the various tasks that you can carry out. Now click on Create stored procedure in designer. This opens the Stored Procedure1:Stored Procedure interface as shown in the next picture.
It comes up with a default template, StoredProcedure1 with an AddTable which shows the various tables in the database (it shows only the three that were imported). Now highlight Products and click on the Add button. This adds the Products table to the designer as shown in the next picture. Close the AddTable window.
From the Products table you choose the columns that are to be added to the Stored Procedure as shown. You just need to place a mark on the check box next to the column name.
Now make a right click on an empty area in the design pane right next to the table. This opens up the context-sensitive help menu as shown. You may use this to add more tables, insert a group by clause, hide the pane or look at the properties of the stored procedure.
Click on the Properties menu item which opens the next window as shown. This is the window where you can fill in all the details of your stored procedure. Since the stored procedure will be created on the MSDE Server, it should follow the various considerations such as naming convention, ownership, permissions, and so forth. You also need to specify the stored procedure parameters calling the procedure, the status of execution, and other statements that are included in the procedure. This window that is shown in the next picture provides you with all this support in a single interface.
Next: A Stored Procedure Without Parameters >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
/ 7 
