databased website with Frontpage 2003

[guido]

after checking the external website via Frontpage 2003, it comes with the
following error.
But my serverhost obligates me to put the database-file in the _private map.

QUOTE
(1) The data connection 'database1' refers to a Microsoft Access database
file '_private/database1.mdb' that is not in the special web folder 'fpdb'
created by FrontPage. Move the file into this folder to avoid potential
security problems.
UNQUOTE

does anybody know what i can do?

 

[Kathleen Anderson [MVP - FrontPage]]

Guido:
I don't believe it's possible to keep the database in the _private folder
and still be able to access it with your query pages. It needs to be in the
fpdb folder or another 'normal' folder. Who is your web host?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Rob Giordano \(Crash Gordon®\)]

sidebar question:

If you decided to put the .mdb in a folder named; fred, what permissions would need to be set on fred?

 

[Kathleen Anderson [MVP - FrontPage]]

I *think* that if, during the import, you tell FP to put the database into a
folder called fred it will give fred the same permissions as it would fpdb

The other option would be to let FP create the fpdb folder and put the
database into it, and then rename the fpdb folder to fred - but you would
also have to edit the string in the global.asa file.


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Rob Giordano \(Crash Gordon®\)]

hmmm.

I think I lost permissions once on fpdb by moving it- even seems there may be a proper order to do this in?..I know I've done it backwards on unix a couple of times and host had to fix the permissions.

Someone should right a Play Book...a more than Noob level and something less than Technogeekazoid Guru-lish.

 

[Rob Giordano \(Crash Gordon®\)]

"write" not right...sheesh.


hmmm.

I think I lost permissions once on fpdb by moving it- even seems there may be a proper order to do this in?..I know I've done it backwards on unix a couple of times and host had to fix the permissions.

Someone should right a Play Book...a more than Noob level and something less than Technogeekazoid Guru-lish.

 

[guido]

Dear all,

host is vip internet Holland,
will try the upload in "fpdb" and rename it on the external homepage to
_private, and edit the global.asa and webconfig.

will let you know what came out
thanks

 

[p c]

You have more flexibility if you set up the mdb folder and your
connection strings on your own without FP.

For security, best practice is to put the MDB files on a folder off the
wwwroot folder, preferably on different drive than where IIS is running.
This way nobody can download it with the URL e.g.
http://mysite/myfolder/myyfb.mdb

But the above may not be an option if you are using host. They tell you
you what folder to use.

Thw folder must have Change permissions (Read, write, modify and Delete)
for the IIS account. This is usually the IUSER_machine. IWAM_machine is
another IIS user account.

...PC