Running .ASP created in Access

[Guest]

I created a project in Access 2003 which has a query based on an SQL 2000
database. The query contains a stored procedure which prompts for a record
ID. When I run the query from Access it works fine, displaying a screen
prompting for my input then displaying the resulting records from the SQL
database. I wanted to be able to run the query from the IE Web browser, so I
exported the query as an .ASP. The .asp file and the .html file (for the
input prompt) were both written to the Web server (IIS). When I run the
query from the browser, specifying the .asp file in the URL, the message is
that a parameter is expected to be passed. If I imbed the query parameter in
the URL it works fine. But shouldn't the .asp file know that it needs to
display the .html file to the user for parameter input? Any help is
appreciated.

 

[Dan Artuso]

Hi,
If you want it to work that way, you have to call the HTML page first, then
have that page page call your asp page, passing the needed parameter.