The next picture shows the stored procedure ByCity on the SQL Express server.
By using Access projects you are leveraging a great back end database with an extremely user friendly front end. Access Project, which was not supported in Access 2003, is now supported except for special features like attachments, multi-valued fields etc.
Creating a project is not very obvious (a function which should have been user friendly). Also the rationale for saving the stored procedure as a query is also not clear. Furthermore when the parameterized query was run with a default value for the "City," the columns displayed appeared to be duplicated. A modify button or control would have been very useful to modify the stored procedure. However a beta version of Access 2007 was used in this tutorial and perhaps the final version may have some of these problems modified.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
/ 21 
