You can ask your webserver administrator if aspnet has got write permissions on the directory where you are putting your database files. Probably it hasn't got those permissions and you cannot do anything about it.

But most probably, you'll find a directory on your webserver which has been setup for storing db files with write permissions set. If you're not sure just send an email to the administrator *after* reading any howtos or readmes provided to you by your host.

Dear to all who concern,

Actually, I've set all right for aspnet account to access the Access DB file. But it still can't get access to the DB file for modification. I think there is some otherelse problem existing in this situation . Please help to find out what the problem is , or is there anything to set apart from the access right??

Thx alot.

William

Once again - - - it's the directory where the Database resides - - NOT the database itself, that needs the permissions set for the ASPNet user account.

I am seeing the same problem as all the above on host server. The system admin has said that all the permissions are set correctly. I can write to the Access db without any problems on my local machine and on a windows 2000 server at the same hosting company. The wilndows 2003 server still has the problem.
Is there something different about writing to an Access db on a Windows 2003 server???

Any help would be greatly appreciated. I am still new at this and it is getting frustrating...

Mike

On Windows 2003 Server the correct user is most probably NETWORK SERVICE instead of ASPNET. Have you asked that on Wk3 server this is correctly set?

Teemu,

This is what I got back from the admin

<<<
Mike,

Essentially when I set the "everyone" user full control, that meant everyone had
full control ;-)

I am still looking for an answer for you but I have not found one. I have checked
other customers ASP .NET BB boards and scripts ETC.. and they all appear to be
working.
>>>

This has really got me stumped. I copied the needed files to both the windows 2000 and 2003 servers. No problem on the Windows 2000 server.

Thanks,

Mike

I have used added <identity impersonate="true" /> to the web.config file which should impersonate the ****_Anon user on the Win2003 server. The admin claims that that user has been given write permission. Even using a simple script to write to a text file it fails witht the following errors. http://sjraces.org/test.aspx Is there something I am missing????

message:

File Creation failed. Reason is as follows

System.UnauthorizedAccessException: Access to the path "E:\Websites\sjraces.org\fpdb\test.txt" is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String str) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, Boolean useAsync, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize) at System.IO.StreamWriter.CreateFile(String path, Boolean append) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize) at System.IO.StreamWriter..ctor(String path, Boolean append) at System.IO.File.CreateText(String path) at _ASP.test_aspx.WriteToFile(Object sender, EventArgs e)

Okay, I've given Everyone full permissions on the folder that contains my .mdb file on my Win2k server, and I'm still receiving the dreaded error...
Are there any other suggestions?

Thanks

Amendment to my previous post: Everything was working correctly last week. I was able to select, update and insert into the database without problem...

Mikhael,

I noticed that your file creation test.aspx page is now working correctly, what did you do to fix the problem???

hi its very dumb for me to post this msg but my error seems to be the same as all of u but after making all the r/w/e access for the mdb file and the folder options , it still does'nt seems to work for me............feeling a little more disappointed after hours of debugging i hope someone can help me out here ...i am jus a dotnet newbie Thanks a million!

Hi jetson,

can tell us what u did? (in detail)

"making all the r/w/e access "
is tat including aspnet account?

if yes, try to add another user account (IUSER).

whats ur error after the change?

Cheers :)
life's Ng

To dear life's Ng and other dotnet Experts

hmm what do u mean by another account or aspnet user account.. where do i create it or where do i find it because my computer only has one administrator account which is me so I do not not where i can set the aspnet user ..or where to add one...can u pls specify more details thanks a lot! :)

Hi Jetson,

look at this link
http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=663579

p/s: im not an experts, im just went thru this problem b4 u :P
Hope this help
life's Ng

Thanks Life Ng! Finally I solve this with ur help :) now i can go on with my development! have a nice day :)