paulchwd

I'm using iis 5 on xp pro sp1. I am trying to run an insert into sql command on an access database. I get this error: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query.

i found out that the Iuser probally doesnt have read/write acces to that folder, how can i fix that though?

aznluvsmc

You have to turn off simple file sharing in Windows XP to get the Windows 2000 style security tab. You can do this by going to Tools > Folder Options > View tab > Use Simple File Sharing (Recommended) in My Computer and unchecking it. The option is at the very bottom of the list.

After doing this, when you right click a folder and choose security you'll see the familiar Windows 2000 interface. Just add the iusr account to the folder and file and give the proper permission.

As a note, this error also occurs when you try to update data but the recordset may not be in a state suitable for updating.

paulchwd

how do i add Iuser ?

Ooble

Clicking the Add button would probably be a good start.

__________________
Me :: You :: Them