IIS Permissions help needed

I think this is a fairly basic question and the frustrating thing is I've
figured it out before but it's been a few years...
I'm using IIS and ASP to interact with an Access database. I can
successfully open a table and display records. However when I try and add a
new record I get an error "Microsoft JET Database Engine (0x80040E09) Cannot
update. Database or object is read-only."

I use the following code:
set objConn = Server.CreateObject("ADODB.Connection")
set objRS = Server.CreateObject("ADODB.Recordset")
objConn.Open strConn
strSQL = "select * from tblHouseHold"
objRS.Open strSQL, objConn,adOpenStatic, adLockOptimistic
if not objRS.eof then
objRS.addnew
objRS.fields("LastName") = "Tester"
objRS.update
End if
Note that I've taken out the code that successfully displays the first
record in this example...

I created a folder outside of the web directory and have created a virtual
directory with read & write permissions pointing to that directory. The
physical folder is not read only. In short, I believe I've checked all the
permissions but somehow I'm missing one somewhere. Can somebody give me the
steps they'd take to set up the folders and permissions to do this task? Be a
hero, I'm doing this development for charity and it's driving me baty.

Re: IIS Permissions help needed

Perhaps this may give you some clues:

http://www.aspfaq.com/search.asp?q=80040E09&x=11&y=10

Best regards,
J. Paul Schmidt, Freelance Web and Database Developer
http://www.Bullschmidt.com
Access Database Sample, Web Database Sample, ASP Design Tips

Re: IIS Permissions help needed

http://www.powerasp.com/content/new/windows_2003_server_and_ permissions.asp

http://www.powerasp.com/content/new/windows_xp_pro_and_permi ssions.asp

http://www.powerasp.com/content/hintstips/permissions.asp


"Jon in Canby Or." wrote in message
news:BB0AC35B-4B8C-45C7-A853-E8C647A6CCE9@microsoft.com...
>I think this is a fairly basic question and the frustrating thing is I've
> figured it out before but it's been a few years...
> I'm using IIS and ASP to interact with an Access database. I can
> successfully open a table and display records. However when I try and add
> a
> new record I get an error "Microsoft JET Database Engine (0x80040E09)
> Cannot
> update. Database or object is read-only."
>
> I use the following code:
> set objConn = Server.CreateObject("ADODB.Connection")
> set objRS = Server.CreateObject("ADODB.Recordset")
> objConn.Open strConn
> strSQL = "select * from tblHouseHold"
> objRS.Open strSQL, objConn,adOpenStatic, adLockOptimistic
> if not objRS.eof then
> objRS.addnew
> objRS.fields("LastName") = "Tester"
> objRS.update
> End if
> Note that I've taken out the code that successfully displays the first
> record in this example...
>
> I created a folder outside of the web directory and have created a virtual
> directory with read & write permissions pointing to that directory. The
> physical folder is not read only. In short, I believe I've checked all the
> permissions but somehow I'm missing one somewhere. Can somebody give me
> the
> steps they'd take to set up the folders and permissions to do this task?
> Be a
> hero, I'm doing this development for charity and it's driving me baty.
>
>
>
>
>