I can't write data to an access database in a webfolder of a windows Prof 2000 machine??

[Norman Fritag]

Hi there,
The Problem:
I can't write data to an access database in a webfolder of a windows Prof
2000 machine, whereas the same web application runs fine under Windows XP.

I looked into the windows security setting for the database and found that
is set to deny write access!
The deny setting applies only to the Windows Security Web application and
Web Anonymous setting, it is Ok for all other User and Admin settings.
Now how do I remove the deny setting in windows security settings??
and from where?
Are there any information on the net?

kind regards

Norman

[Ken Schaefer]

Hi,

Can you post the exact error message you are seeing? Most of what you posted
doesn't really make any sense.

For an Access .mdb file, you can give Change (RWXD) NTFS permissions to the
folder that the .mdb file is in (and all files contained within that
folder). Do to this, open an Explorer window, right-click on the folder and
choose "Security". You need to give the IUSR_<machinename> account these
permissions (assuming you are allowing anonymous access, and you haven't
changed the account that anonymous access is impersonating)

If this folder is contained inside your website, make sure that in the IIS
Manager, you have removed IIS Read permissions, otherwise people can
download you database by typing in
http://yourserver/databases/yourdatabase.mdb
Better to store the database outside the webroot.

Cheers
Ken

"Norman Fritag" <mt*****@ozemail.com.au> wrote in message
news:bO****************@nnrp1.ozemail.com.au...
: Hi there,
: The Problem:
: I can't write data to an access database in a webfolder of a windows Prof
: 2000 machine, whereas the same web application runs fine under Windows XP.
:
: I looked into the windows security setting for the database and found that
: is set to deny write access!
: The deny setting applies only to the Windows Security Web application and
: Web Anonymous setting, it is Ok for all other User and Admin settings.
: Now how do I remove the deny setting in windows security settings??
: and from where?
: Are there any information on the net?
:
: kind regards
:
: Norman
:
:

[Paul Clement]

On Tue, 2 Dec 2003 17:57:14 +1100, "Norman Fritag" <mt*****@ozemail.com.au> wrote:

¤ Hi there,
¤ The Problem:
¤ I can't write data to an access database in a webfolder of a windows Prof
¤ 2000 machine, whereas the same web application runs fine under Windows XP.
¤
¤ I looked into the windows security setting for the database and found that
¤ is set to deny write access!
¤ The deny setting applies only to the Windows Security Web application and
¤ Web Anonymous setting, it is Ok for all other User and Admin settings.
¤ Now how do I remove the deny setting in windows security settings??
¤ and from where?
¤ Are there any information on the net?

See the following:

PRB: Cannot Connect to Access Database from ASP.NET
http://support.microsoft.com/default...Product=aspnet

INFO: Permissions to Connect to a Remote Access Database from ASP.NET
http://support.microsoft.com/default...Product=aspnet
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

[Jeff Cochran]

On Tue, 2 Dec 2003 17:57:14 +1100, "Norman Fritag"
<mt*****@ozemail.com.au> wrote:

I can't write data to an access database in a webfolder of a windows Prof
2000 machine, whereas the same web application runs fine under Windows XP.

I looked into the windows security setting for the database and found that
is set to deny write access!
The deny setting applies only to the Windows Security Web application and
Web Anonymous setting, it is Ok for all other User and Admin settings.
Now how do I remove the deny setting in windows security settings??
NTFS permissions using Windows Explorer. You need MODIFY access for
the anonymous user (IUSR) account to both the folder and the file.
Are there any information on the net?

Try your help. Look at NTFS permissions.

Jeff

[Geo]

Why is this different on XP?

-----Original Message-----
On Tue, 2 Dec 2003 17:57:14 +1100, "Norman Fritag" <mt*****@ozemail.com.au> wrote:
¤ Hi there,
¤ The Problem:
¤ I can't write data to an access database in a webfolder of a windows Prof¤ 2000 machine, whereas the same web application runs fine under Windows XP.¤
¤ I looked into the windows security setting for the database and found that¤ is set to deny write access!
¤ The deny setting applies only to the Windows Security Web application and¤ Web Anonymous setting, it is Ok for all other User and Admin settings.¤ Now how do I remove the deny setting in windows security settings??¤ and from where?
¤ Are there any information on the net?

See the following:

PRB: Cannot Connect to Access Database from ASP.NET
http://support.microsoft.com/default.aspx?scid=kb;en- us;316675&Product=aspnet
INFO: Permissions to Connect to a Remote Access Database from ASP.NEThttp://support.microsoft.com/default.aspx?scid=kb;en- us;307901&Product=aspnet

Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
.

[Paul Clement]

On Tue, 2 Dec 2003 06:58:50 -0800, "Geo" <an*******@discussions.microsoft.com> wrote:

¤ Why is this different on XP?

There shouldn't be a difference as both use the same security mechanism.
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)