I know how to execute a stored procedure in Access. However, I'm trying to 
use script to display "paged" sets of records, and it calls the SQL 
several times throughout the script.

What I'd like to do, is to be able to read a query stored in Access, get 
the SQL, and set it as a variable in my page to be used several times. 

Is this even possible? Any advice is appreciated, thanks!

If you are looking to BUILD the SQL statement for an existing
Access query, take a look at this site.  It makes it easy--and
free!  http://solutions.lwoods.com/buildsqlstring.asp .

Larry Woods
l.woods, inc.

> -----Original Message-----
> From: Eric Barsamian [mailto:ebarsamian@n...]
> Sent: Tuesday, October 15, 2002 4:22 PM
> To: Access ASP
> Subject: [access_asp] Can I read the SQL out of an
> Access Query?
>
>
> I know how to execute a stored procedure in Access.
> However, I'm trying to
> use script to display "paged" sets of records, and it
> calls the SQL
> several times throughout the script.
>
> What I'd like to do, is to be able to read a query
> stored in Access, get
> the SQL, and set it as a variable in my page to be
> used several times.
>
> Is this even possible? Any advice is appreciated, thanks!
>

Close, that's what I'm looking to do, but dynamically.  I have the query 
already in Access, What I want to do, is when my ASP page is executed, to 
go and read the query, and then write the SQL line to a variable to be 
used later on in the script.

Any other suggestions?  Thanks!