Altering an Access db from ASP in XP

[Jonax]

Hi all,
I have this annoying problem which is:
I can't seem to INSERT, UPDATE or DELETE - onle SELECT.

I think it has to do with permissions, but I've tried unwriteprotecting the file, the folder etc.
I've also tried giving it write permissions in MMC

Did it help?! -No such luck...

I searched MSDN and the Microsoft newsgroups, and I found a guy with the same problem, but no solutions...

Just to set it straight, the code DOES work on NT/2k, I've also tried using the AddNew-method of ADO, but it all amounts to the same...

 

[cschaffer]

Are you getting an actual error on the asp results page??
and if so what is it?

CS

 

[Jonax]

Ok, I've figured it out...
It's as simple as choosing to webshare the folder containing the db, and give it write-permissions (duh!)...

Anyway, hope this will help others facing the same prob...

 

[cschaffer]

You must have been getting "must use an updatable query" error??!!

Good to know you fixed it..!

CS

 

[Jonax]

Yup, amongst others...
Thx anyway ;-)