Frontpage 2002 password protected page

[Ronx]

I have used your code to create pages in a subweb. With a few
"cosmetic" changes to suit the location of the subweb your code works.
I did make one other change:

In logon.inc I changed

objCN.Open "driver={Microsoft Access Driver (*.mdb)}; dbq=" & _
Server.MapPath(MDB_URL) & "; uid=admin; pwd="

To

objCN.Open Application("Database1_ConnectionString")

because the code as written (changed to suit my web) caused a JET
database read error.

When you imported the database you should have been asked to move the
database to fpdb folder, and to create a database connection.
In the logon subweb's root there should be a file named global.asa -
this file contains the database connection, and
Application("Database1_ConnectionString") references this connection
string.


--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp

 

[defraine]

Hi Ron,
Thanks. Will try. Am I right in saying this can ONLY be done connected to
my remoteweb. ie. I CAN'T do it locally on my C drive with preview and I
HAVE to be ONLINE?
Cheers

 

[Ronx]

If you are using a server based web, accessed in FrontPage using
http://localhost/ or http://localhost/webname then it can be done
locally. Otherwise you can set up the files required, but must publish
to a server to test.
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp

 

[defraine]

Thanks, was all down to me being on my C drive and not using remote server.

Thanks for your time and hanging in there.

Sean

 

[JC]

I have been having problems with the same KB and I want to do the same thing,
password protect a "members page" I have gone through and what I can see
followed everything correctly.

www.29FireRescue.com/Logon

The I am able to get to the logon page, I enter testuser and password and
when I click logon I get directed to "HTTP 500 Internal Server Error Page"

I put the logon.mdb into a folder i created called FPDB through the import
function as was indicated in the posts with this discussion. I did change to
point to FPDB where it was pointed to go to _private.

I have as follows in subweb logon:
default.asp
logon.asp
nonsecure.asp
passwordprotect.asp

in folder FPDB i have:
logon.inc
logon.mdb

Any help anyone can provide, would be greatly appreciated.

 

[Thomas A. Rowe]

You need to let FP create the fpdb folder when prompted, during the database import.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================

 

[JC]

I was never prompted for them to create the folder. Here is what I did:

File | Import | File | Add File | I choose the logon.mdb file | frontpage
showed the URL as logon.mdb.accdb | clicked ok and it was uploaded

 

[Thomas A. Rowe]

Delete your current FPDB folder and the database, the global.asa file, then drag-n-drop the .mdb
file into your current open FP site.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================

 

[JC]

Hm...
It seems not to be working. I tried to drag-n-drop it into the folder list
and all it does the same thing as when I import, just lists the
logon.mdb.accdb file, no FPDB folder. Also there isn't any global.asa file...

 

[JC]

Just an idea, since I can't seem to get it to work, would you be able to
create that and then send me the file? Would that be sufficient?