www.webdeveloper.com
Results 1 to 5 of 5

Thread: Can't write into a database

  1. #1
    Join Date
    Feb 2004
    Posts
    1,345

    Can't write into a database

    Hi There.

    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

  2. #2
    Join Date
    Jun 2003
    Location
    Indiana, USA
    Posts
    1,138
    make sure that the whole folder the db is in grants all users the right to change or modify

  3. #3
    Join Date
    Feb 2004
    Posts
    1,345

    got it

    Thanks

  4. #4
    Join Date
    Nov 2002
    Location
    Auburn, AL
    Posts
    9,222
    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.

  5. #5
    Join Date
    Jan 2004
    Location
    Melbourne, Australia
    Posts
    5,298
    Full IUSR priviledges must be set.

    Also, make sure your Database is located within the wwwroot/inetpub directory. It can be a sub-directory.

    Regards.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles