Saving ASP pages from Access

[Juke]

Stupid question here, at least I hope it has a easy answer.

I created a ASP page inside access 2003 and would like to
use it with an intranet web site, local accress
192.168.X.X. How am I supose to save the ASP page and get
it to access the database that is part of the web site. I
have ASP pages created in Frontpage that work correctly,
but wanted to use the ASP page created in access, just
don't know how to save it properly...

Please help, or point me in the right direction.

Thanks

 

[Dan Artuso]

Hi,
The asp page should be saved in the appropriate directory on your web
server.

HTH
Dan Artuso, MVP

 

[Guest]

Thanks for the reply,

What is the appropriate page on my web server and how do I
access it. I have to change the connection string from
the local link (e.g. S:\Database\database.mdb) to the URL
of the database (e.g. http://198.162.X.X) or should I
point directly to the database file
(http://192.168.X.X/fpdb/database/mdb)? Nothing seems to
work. I'm really missing the boat on this one.

Thanks

 

[Dan Artuso]

Hi,
Okay, usually the Access database will be on the same machine that is your
web server. It's beyond what I can post here to tell you how to set up your
site on the web server. Any book on IIS will go through that step by step.

I can tell you that you cannot use: http://whatever in your connection
string.
The mdb file must be in a shared directory (on the web server itself.)
and the appropriate permissions must be set on that directory. This will
usually be
change permissions for IUSR_MachineName as that is the account that IIS
uses.
You then can use: S:\Database\database.mdb
to point to the mdb.

It's hard to go into every detail so I would recommend that you pick up a
good book
on IIS or google on IIS or asp pages.

HTH
Dan Artuso, MVP