Access 97 database on intranet

[sunnywink]

Hi all

I am trying to put up an entire database on the intranet with queries and report.

I am new to this topic. I understand that with the following commands, i can set up the database on the net where users can enter this ASP page to do editing:

<%
dim myconnection
set myconnection = Server.createobject(&quot;ADODB.connection&quot
myconnection.openProvider=Microsoft.Jet. OLEDB.3.51;&quot;_
&&quot;DataSource=Pathname of datasource&quot;
%>


I know as for query, we can set them using the SQL language.

But how can the user select a query to run? Do they go to the query view on the Access database as in normal database application, and double click to do query?

And how will the server recognise which query the user has selected? In addition, how can dynamic reports be run?

Many thanks in advance.