Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/67126?pagenum=1
05 November 2025, 09:51
Topic
Jorrit787
Access DB not updateable on localhost?
26 May 2008, 07:59
I've been working on an ASP project and I've been running it from my own PC with IIS, but every time I try to use INSERT or DELETE on my Access DB it gives me the "operation must use an updateable query" error. Are Access databases stored on the localhost somehow not writeable? It works fine when I run it on a web server.<
Replies ...
Carefree
26 May 2008, 09:15
Check your read/write permissions on the folder in which the database is contained.<
AnonJr
26 May 2008, 11:57
Make sure the IUSER account has read/write access to the folder and the file. Even if you're hosting locally, this advice still works: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=16559 <
Jorrit787
26 May 2008, 20:14
The folders in my wwwroot directory don't have a security tab... I'll see if unchecking read-only on the database folder helps.<
AnonJr
26 May 2008, 22:21
If you're running XP you'll need to turn off "Simple File Sharing" in your file/folder options<
Jorrit787
27 May 2008, 00:19
Originally posted by AnonJr If you're running XP you'll need to turn off "Simple File Sharing" in your file/folder options