Hi,

I am able to read and write to my database on my local machine without any problems.

However after I hosted my site I am able to read from my database but receive an error when I write to it. The error I get is that I have to use an updatable query.

I have added the IUSR permissions to the database file (access .mdb) before uploading to my site and my hosting site has told me that the folder it is in also has write permissions.

Does anyone else have any ideas what is wrong??

Thank You

You're posting this in a .NET forum, so maybe you are using ASP.NET?

If that's the case, you don't need the IUSR account, but ASPNET or Network Service instead.

Take a look here:

http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=263
http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=287

for more details.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Thanks for that.

However, I am changing the permissions on my local machine and then uploading to my host site. When i then download the DB from the host site, the permissions that I had added are gone.

I don't understand why this is happening.

Security settings only apply to the system where they are set; transferring a file by FTP basically erases all associated security settings. When you save the file locally on disk, the settings for the parent folder on the local system apply, not those from the remote host.

Similarly, when uploading files, the settings are removed as well. So, you can't set the settings locally and then upload the file to a folder on the server. Your hosts needs to apply security on the database folder.

Hope this helps,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Yes that must be my problem. Thank you very much!