Hi all
I am tasked to put up an entire database on the intranet with multiple 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("ADODB.connection"
myconnection.openProvider=Microsoft.Jet. OLEDB.3.51;"_
&"DataSource=Pathname of datasource"
%>
I know as for query, we can set them using the SQL language.
Eg.
Set rsTitleList=myconnection.Execut(Select * from List)
But I am confused about how will the user be able to 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 set up to reflect the updated information?
Many thanks in advance.
I am tasked to put up an entire database on the intranet with multiple 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("ADODB.connection"
myconnection.openProvider=Microsoft.Jet. OLEDB.3.51;"_
&"DataSource=Pathname of datasource"
%>
I know as for query, we can set them using the SQL language.
Eg.
Set rsTitleList=myconnection.Execut(Select * from List)
But I am confused about how will the user be able to 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 set up to reflect the updated information?
Many thanks in advance.