[WEB4LIB] MS Access data page

[J Crockett]

Liz,

If the publicly accessible Web server, where the file resides, has FrontPage
extensions and you have Microsoft FrontPage installed on your computer,
there are wizards in FrontPage that will create the database results ASP
Pages for you.

Your database file must be in a "fpdb" directory on the Web server.  Open a
new page in your FrontPage, click "Insert" - "Database" - "Results", and the
wizard will open to create a connection to the database.  That will walk you
through creating the query you want, or you can paste the SQL code for the
query from MSAcccess as a custom query in the wizard.  More customization is
possible than is apparent.  Play around with it and you'll find other
solutions.  In the process, you could learn some ASP from examining the page
source.

Joleen

-----Original Message-----
From: web4lib at webjunction.org [mailto:web4lib at webjunction.org]
On Behalf Of LizPerlman.7901733 at bloglines.com
Sent: Friday, April 15, 2005 10:47 AM
To: Multiple recipients of list
Subject: [WEB4LIB] MS Access data page 


I'm probably going about this all wrong, but this is the only option I have
right now.  We have an MS Access database which we'd like to be able to
query (but not update) via the Web.  I've been able to build a data access
page in Access, but it insists on keeping the path what I originally gave it
(a mapped drive), and will not accept a URL.  However, most people in the
college do not have this drive mapped, nor do they have access to the
server.  However, the file resides on a publicly accessible Web server.  I
feel like I'm so close to making it work, but am not quite there.  I do not
know ASP so that's not an option right now.  Does anyone have a suggestion?

Liz Perlman, MSLIS

Systems Librarian
Specker Memorial Library
Calumet College of St. Joseph

2400 New York Avenue
Whiting, IN  46394
219-473-4374 (office)
219-473-4259
(fax) 
eperlman at ccsj.edu