Access Databases on a Front Page Web?

[Gil]

Perhaps this is a question for the Access Forum, but I was hoping for a hand here. I have a Microsoft Access Database being used mostly for Chemical Inventory and MSDS re-certification. I was wondering how I can have the database accessible from the web (I used Front Page to publish my web site). The Access output to HTML format doesn't really allow the user to specify where on web servers the database was located, or anything...<br>
<br>
Thanks,<br>
Gil

 

[DougP]

Looks like a Job for Active Server pages .ASP<br>
Access '97 & 2000 can create an HTML of just about anything<br>
tables reports etc.<br>
But ASP requires a lot of other software be installed at the on the WEB server.<br>
<br>
Check this out too.<br>
<br>
To create a database region<br>
<br>
1 On the FrontPage Editor’s Insert menu, point to Database, then choose Database Region Wizard.<br>
<br>
The Database Region Wizard is displayed. Use this tool to configure SQL queries to an ODBC-compliant database accessible from the Web server computer.<br>
<br>
2 In the Database Region Wizard, edit the settings you want to configure or change.<br>
3 Click Finish to save your changes.<br>
<br>
Note Before you can integrate a database into a FrontPage 98 web, you must follow a series of steps that take place outside of FrontPage. These include configuring your Web server and workstation, and building (and modifying) Structured Query Language (SQL) queries in a database management tool such as Microsoft Access. Please see the Getting Started with Microsoft FrontPage 98 book for more information on FrontPage 98 Database Integration.

 

[Gil]

Thanks a lot... You answered a lot of my questions from the Front-page side of things. If anyone is looking for some answers to the server problems, and some of the steps required in Access, go to the following page, I found it very useful (albeit a little simplified, but you'll get the idea).<br>
<A HREF="

http://cvoc.bus.lsu.edu/students/ramki/ppfiles/accessasp/sld025.htm"

TARGET="_new">

http://cvoc.bus.lsu.edu/students/ramki/ppfiles/accessasp/sld025.htm</A><br>

<br>
Thanks again,<br>
Gil