It returned a recordset which I used to print out this name: Andrew Fuller.
After my recent sample on SQL Server stored procedures, I
got a number of requests for something similar in Access.
While you won't get the same performance benefits you do with SQL
Server, you can use stored queries in Access to move
the query text out of your ASP code.
While they don't give you the performance boost you get with
SQL Server's stored procedures, they can get you started developing
better solutions by removing your database specific code from
your ASP scripts. This can make switching databases easier
should the need arise.
It might also help alleviate some of the problems people have
been having with SQL injection attacks.
The database is a slightly modified (to include the query)
version of our standard sample database and can be downloaded from
here (160 KB).