Access DB not updateable on localhost? - Posted (1038 Views)
Average Member
Jorrit787
Posts: 681
681
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.<
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Advanced Member
Carefree
Posts: 4224
4224
Check your read/write permissions on the folder in which the database is contained.<
Posted
Forum Moderator
AnonJr
Posts: 5768
5768
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 wink<
Posted
Average Member
Jorrit787
Posts: 681
681
The folders in my wwwroot directory don't have a security tab... I'll see if unchecking read-only on the database folder helps.<
Posted
Forum Moderator
AnonJr
Posts: 5768
5768
If you're running XP you'll need to turn off "Simple File Sharing" in your file/folder options<
Posted
Average Member
Jorrit787
Posts: 681
681
Originally posted by AnonJr
If you're running XP you'll need to turn off "Simple File Sharing" in your file/folder options
That did it, thanks.<
Posted
Forum Moderator
AnonJr
Posts: 5768
5768
Your welcome. smile<
 
You Must enter a message