Access DB not updateable on localhost? - Postet den (1041 Views)
Average Member
Jorrit787
Innlegg: 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.<
   
 Sidestørrelse 
Postet den
Advanced Member
Carefree
Innlegg: 4224
4224
Check your read/write permissions on the folder in which the database is contained.<
Postet den
Forum Moderator
AnonJr
Innlegg: 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<
Postet den
Average Member
Jorrit787
Innlegg: 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.<
Postet den
Forum Moderator
AnonJr
Innlegg: 5768
5768
If you're running XP you'll need to turn off "Simple File Sharing" in your file/folder options<
Postet den
Average Member
Jorrit787
Innlegg: 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.<
Postet den
Forum Moderator
AnonJr
Innlegg: 5768
5768
Your welcome. smile<
 
Du må legge inn en melding