2. ASPRunnerPro General questions
  3. Internet Guest Account
This topic is locked

Internet Guest Account

 		2/4/2004 03:56:36
ASPRunnerPro General questions
R
 rudge357 author

I am very new to ASP Runner, still in the evaluation period - I am getting error I cannot seem to solve
"operation must use an updatable query" when I try to write data to the database
All the help I find online about this error suggestes I check the (Iusr_machine) internet guest account to see if it has write permissions for the database file. Where and how do I do this ? Microsoft suggests using the security tab in explorer to set the properties for the file - I cannot find any security tab ?
I am a little lost here - any pointers
thanks <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=337&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
Sergey Kornilov admin 2/4/2004

Hi,
I'd be glad to help you. Please tell me the following:

  1. You test ASP pages locally or on your Web server?
  2. If you test it locally what is your operating system?
  3. Your file system is NTFS or FAT32?
R
 		rudge357 author 2/4/2004

Thanks for the offer to help
This error occurs when I preview the page locally and also when I access the page via the web server from another machine.

****

ASP error
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

insert into [SALES] ([LOT #], [QTY SOLD], [PRICE]) values (22, 22, 12)
****

Server is running Windows XP Pro, use IIS for serving the web and have a NTFS file system
Database is Access 2000, installed in the ASPRunner "output" directory where the ASP pages are stored. Directory has read/write properties.
Hope this is enough infomation.
Thanks
Steve
Sergey Kornilov admin 2/4/2004

Steve,
here is what you need to do to enable Security tab.
Go to Start -> Control Panel -> Folder options. Go to View tab. Scroll down to the end and uncheck Use simple file sharing (recommended). Click OK.
After that right-click on the database file you you will see Security tab.
I hope this helps.
R
 		rudge357 author 2/4/2004

Thanks, I to got the security tab and made the setings suggested for the database file. But i still have the same error.
I guess this was not the problem...need to think some more.
ASPRunner is not as easy to impliment as I had hoped. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=1039&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />
Thanks
Steve
R
 		rudge357 author 2/4/2004

Fixed the problem. I had to set "everyone" write access rights to the folder containing the database.
Thanks for the help <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=1040&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
Steve