[WEB4LIB] Connecting an Access db to a Web page

[Chris Gray]

I've just succeeded in putting up a test project using Microsoft Personal
Web Server and Access 97 to make small databases Web accessible.  One of
the biggest problems was finding the information I needed.

Books on Access 97 and Access 97 programming turned out not to be very
helpful.  You might find more information in books on Internet Information
Server since Personal Web Server is a slimmed down version of IIS.  One
book that is supposed to have good coverage of MS Web dbs is Internet
Information Server 4 Administrator's Guide by Allen L. Wyatt.  Another book
that I just picked up looks excellent: Choosing a Database for Your Web
Site by John Paul Ashenfelter.  It has a Web site at:
http://www.wiley.com/compbooks/ashenfelter/

I found some helpful starting places rummaging around in Microsoft's MSDN
library, for example:

Publishing Databases on the Intranet Using Personal Web Server and
Microsoft Access97
http://msdn.microsoft.com/library/periodic/period97/html/pws.htm

An Introduction To Two Approaches: Dynamic Publishing Over The Web 
http://msdn.microsoft.com/library/periodic/period98/html/adj9823.htm

Setting Up a Personal Web Server 
http://msdn.microsoft.com/library/officedev/office/html/settinguppersonalweb
server.HTM

There are detailed reference documents at this site for the various bits
and pieces you'll need like ODBC, Jet, and IDC/HTX.

Chris Gray
Library Systems Technician
University of Waterloo

At 12:32 AM 1999-02-25 -0800, Helen Cotsell wrote:
>Hi, All,
>
>I'm at the beginning of this process, and I admire Gary's on-line =
>journal
>list - and wish I was as far along as he is.  Mine are still done by =
>editing
>the HTML - so I would like to make a journal list database accessible =
>from
>my Web site, and easier to update, using an Access form, so that I don't
>have to do it myself.
>
>Could anyone advise me of useful titles dealing specifically or mainly =
>with
>the ins and outs of exporting an Access database to a Web page?  I have =
>the
>two MS Press books (MS Access97 Step-by-Step , ditto Visual Basic), but =
>if
>they say anything to the point, I must have missed it...
>
>Helen