Please help - permissions problem

I have been working on this one problem for almost 2 weeks now. I'm trying to get my server to allow me to write to an access database from an ASP page. The server keeps returning one of 2errors:<br>Operation Must Use an Updateable Query<br>Cannot update. Database or object is read-only<br><br>I checked in the properties dialog box of the database (from windows explorer) and saw that the file is not read only. The virtual directory is set to read write access (from Microsoft Management Console) and I can't figure out why it won't let me write to a database.<br><br>I think I found an article on Microsoft's website that answered my problem, but I don't quite understand it. This is the part I don't understand:<br><div class="msgQuoteWrap"><div class="msgQuote"><b>Microsoft said...</b><br />"The most common reason is that the Internet Guest account (IUSR_MACHINE), which is by default part of the "Everyone" group, does not have Write permissions on the database file (.mdb). To fix this problem, use the Security tab in Explorer to adjust the properties for this file so that the Internet Guest account has the correct permissions."</div></div><br>Maybe I'm an idiot, but I can't find the "Security tab" in explorer. It seems like it would be in the properties dialog box when you right click on a file, and click properties, but it isn't there.<br><br>The article refferenced at microsoft.com is at:<br>http://support.microsoft.com/default.aspx?scid=kb;en-us;175168<br><br>My system info just in case it helps is:<br>OS - Windows XP pro<br>Server - IIS 5<br>Database - Access 2002<br><br>PLEASE HELP! I've been racking my brains for over a week now, and I can't seem to figure this one out. Any help, or suggestions would be GREATLY appreciated.<br><br>Thanks,<br>Ryan

If you aren't seeing the security tab, then you probably aren't logged in as a local administrator. <br><br>Regarding the main issue of not using an updatable query, can you post the code you are trying to use that is not working (or a link to where we can see the code)?<p> </p><p><hr size="1" width="50%" align="left" />dotNetBB Forum Developer<br><b><i>Building A Better Community, One Post At A Time</i></b><br><a href="http://www.dotnetbb.com" target="_blank">www.dotnetbb.com</a></p>

I know that the code works, because I didn't write it. I downloaded it so I could try to understand it, and then write my own. I'm learning ASP right, and I learn best by example. And by the way, I've downloaded at least 5 different versions, by 5 different authors, and they all give me the same problem, so I know that it isn't the code.<br><br>Secondly, the administrator thing sounds like that could be the answer I'm looking for. I log in as "Ryan" when I start the computer, because that's my name, and that's the only option it gives me. I installed XP, but I honestly don't know that much about it.<br><br>How would I log in as the local administrator? I know its a stupid question, but if you could please answer it, this dummy would be a happy dummy.<br><br>Thanks,<br>Ryan

For everyone else.. The issue was resolved offline. The problem was a combination of not using the "Classic login" style for XP with having "Simple File Sharing" enabled on the folders.<br><br>The "Classic login" setting can be changed in the "User Accounts" applet in the control panel.<br><br>Disabling "Simple File Sharing" can be done by adjusting the folder properties under the advanced section of the view tab modifying a folder's property.<p> </p><p><hr size="1" width="50%" align="left" />dotNetBB Forum Developer<br><b><i>Building A Better Community, One Post At A Time</i></b><br><a href="http://www.dotnetbb.com" target="_blank">www.dotnetbb.com</a></p>