Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Stupid SQL noob question.... do I use Access? 2
- Thread starter JESTAR
- Start date
-
2
- #2
The databases are stored on computers connected to the internet. The database engine could be Access. Instead of VBA forms and reports, a query would start with an HTML page consisting of a form; the information retrieved from the database would be displayed in an HTML page. The HTML pages are files stored where the web server can find them.
The input form could be a static HTML page, always the same. The output page would be a dynamic page, a temporary page containing the results of the query. This dynamic page is created by a program that you write, usually by a type of program called a script.
The script is also stored on the web server. The name of the file containing the script will be mentioned in the form as an action <form action="/cgi-bin/results.pl">,
<form action="results.asp">, or some such.
Clicking on the submit button causes your browswer to send a request to the web server for the script, together with any data in the form fields.
The server will look for the script and execute it. The script will connect to the database, provide a SQL statement, receive the results, and use them to build an HTML page. The web server responds with that dynamic HTML page.
In order to do these things you need an ISP that provides the capabilities of running a database engine, and of executing scripts. These scripts might be written in Perl and located in a directory called cgi-bin, or they might be written in ASP plus VBScript. Either way these capabilities usually cost extra if they are available at all.
As for the database engine, again that will be run by the ISP, who might provide Access or some other brand.
The database file such as PetStore.mdb might be stored in a directory with your other HTML files. It will be useless without Access running on a computer which the script can connect to. This is most likely going to be a computer operated by the ISP.
So you see it is a long way from here to there. The place to start is by contacting your ISP.
The input form could be a static HTML page, always the same. The output page would be a dynamic page, a temporary page containing the results of the query. This dynamic page is created by a program that you write, usually by a type of program called a script.
The script is also stored on the web server. The name of the file containing the script will be mentioned in the form as an action <form action="/cgi-bin/results.pl">,
<form action="results.asp">, or some such.
Clicking on the submit button causes your browswer to send a request to the web server for the script, together with any data in the form fields.
The server will look for the script and execute it. The script will connect to the database, provide a SQL statement, receive the results, and use them to build an HTML page. The web server responds with that dynamic HTML page.
In order to do these things you need an ISP that provides the capabilities of running a database engine, and of executing scripts. These scripts might be written in Perl and located in a directory called cgi-bin, or they might be written in ASP plus VBScript. Either way these capabilities usually cost extra if they are available at all.
As for the database engine, again that will be run by the ISP, who might provide Access or some other brand.
The database file such as PetStore.mdb might be stored in a directory with your other HTML files. It will be useless without Access running on a computer which the script can connect to. This is most likely going to be a computer operated by the ISP.
So you see it is a long way from here to there. The place to start is by contacting your ISP.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question