How Do I make password access to a database already in Frontpage?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have taken on the task of overseeing a website already in existance. They
have a data base which much to their surprise is freely visible from the
web.. Chances of someone stumbling onto the url is slim, but they are
disturbed by this.

How can I make this database password protected.
 
Depends on your host and is the support DSN or not
- move the DB out of the root web (to a folder at same level or a folder above the root web)
- then use a server based path or DSN to connect to it

PS
If the site is using the FP SE and the DB is in the fpdb folder (created by File import the db into the FP site) it is not visible
or openable to the users browser

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I have taken on the task of overseeing a website already in existance. They
| have a data base which much to their surprise is freely visible from the
| web.. Chances of someone stumbling onto the url is slim, but they are
| disturbed by this.
|
| How can I make this database password protected.
 
The database is not in the fpdb folder, but made up of several files placed
in the general webpage directory. THe database gathers information from a
registration form, also allows for members of this organization to make
changes to their information, etc...

THis is a frustrating situation, and if it wasn't for the size of the
database, I would probably scrap it and start over again the right way.

Am I looking at a major job to move these files into the fpdb folder, or can
I simply move them there after changing any linking urls in the webpage?

Thanks
CG
 
Don't create the folder or move them yourself
File Export the DB files to your desktop or a folder on your PC
Then File Import them back into the FP web
- FP will ask if you want them in the fpdb folder (yes) and to provide names for them, plus create a new or updated global .asa file
(it will set the permissions on the fpdb folder)
- check your DB connection strings after doing so

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| The database is not in the fpdb folder, but made up of several files placed
| in the general webpage directory. THe database gathers information from a
| registration form, also allows for members of this organization to make
| changes to their information, etc...
|
| THis is a frustrating situation, and if it wasn't for the size of the
| database, I would probably scrap it and start over again the right way.
|
| Am I looking at a major job to move these files into the fpdb folder, or can
| I simply move them there after changing any linking urls in the webpage?
|
| Thanks
| CG
|
|
| "Stefan B Rusynko" wrote:
|
| > Depends on your host and is the support DSN or not
| > - move the DB out of the root web (to a folder at same level or a folder above the root web)
| > - then use a server based path or DSN to connect to it
| >
| > PS
| > If the site is using the FP SE and the DB is in the fpdb folder (created by File import the db into the FP site) it is not
visible
| > or openable to the users browser
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > |I have taken on the task of overseeing a website already in existance. They
| > | have a data base which much to their surprise is freely visible from the
| > | web.. Chances of someone stumbling onto the url is slim, but they are
| > | disturbed by this.
| > |
| > | How can I make this database password protected.
| >
| >
| >
 
Back
Top