Frontpage 2002 password protected page

R

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
 
D

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
 
D

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
 
J

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.
 
T

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
==============================================
 
J

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
 
T

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
==============================================
 
J

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...
 
J

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top