Can't write into a database
I'm trying to make a simple INSERT INTO but I keep getting this message:
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
I read that this might be the problem:
The permissions on the database itself does not have full read/write privileges in effect.
How can I check out the permissions on the database?
What to do if it's still won't work?
Thanks a lot
make sure that the whole folder the db is in grants all users the right to change or modify
Some things Man was never meant to know. For everything else, there's Google.
Yes if your on xp you would have needed to turn off simple share. BTW all users do not need to modify the data base, I preferr to stay away from that, it makes me paronoid, I just give ASPNET (since I use asp.net) and other system accounts that would be running the scripts. But if you do not feel like looking for them on the list then all users will do it.
Full IUSR priviledges must be set.
Also, make sure your Database is located within the wwwroot/inetpub directory. It can be a sub-directory.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)