connecting to access db for update from web app

[Andy Smith]

Hi- newbie post... so it'll probably be an easy answer

I'm building a web app in which my students may submit an answer to a
trivia question via aspx page.
(http://www.sciencesmith.org/submit/trivia_submit.aspx) Access DB
stores student name and answer via UPDATE command.

When submit button is pressed (go try it!), a box pops up asking for
user name and password, title bar says "Connect to
www.sciencesmith.org".

I'm passing userID and password as part of connection string.

No matter what I type for username and password I get "You are not
authorized to view this page". HTTP error 401.1

Of course user should not have to enter these things anyway... I'm
just trying to establish SOME connection to my database.

**I should note that this works fine on my local machine when
developing the site with VS.NET... I only have a problem after I've
uploaded my db and page to web server. I checked with web server and
established a DSN for the database, setting a username and password
(which is what I passed in the connection string).

** I'm thinking this should be a very simple task, not sure where I'm
tripping up.

THANKS IN ADVANCE!

-Andy

 

[Scott M.]

The folder that the file
"F:\Hosted-Sites\10-sciencesmith.org\www\xmldata\triviaSolutions.txt" is in
(xmldata) is NTFS protected.

Make sure that this folder allows the aspnet user to access it.