publish database on the web

[RAKESH]

I have a database done in Access 97 and I want to publish the forms and queries on the web,but dont seem to understand to do it in a dynamic format.

 

[EuanPirie]

You need to use Microsoft Active Server Pages. These run on the server, thereby (thereoretically) putting to one side the issue of which what browser the user is using, and return HTML to the user. You can create simple forms fairly easily, and running SQL reports is ok as well. ASP can run queries, and return reports(although this is where I am currently stuck). You can manipulate the data fairly easily, by using (your choice) of Visual Basic script or Java script. I choose VB script as there are a lot of helpful web sites out there. You will need a server running either IIS(NT 4) or Personal web Server (win 95). I used NT and found the web publishing tools to be much easier to use. Also, you need to configure the ODBC (not that tricky).<br>
<br>
Be warned - if you don't have a fast machine - it'll run like a pig. I used a P200 to develop on. Also, you need to check with your ISP that they can publish the database.