Operation must use an updateable query.

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • middletree

    Operation must use an updateable query.

    I recently moved my files to a new machine that I am writing my code on.
    When I attempt to do anything to the ACCESS database through the ASP pages,
    I get the "Operation must use an updateable query" error. I know the first
    thing to do is go to www.aspfaq.com, and it advises me that it's probably a
    permissions thing, and I need to add IUSR pemissions.

    Problem is, I have no idea how to do this. I thought it would be pretty
    easy. I've added sharing permissions before for normal networking-type
    things at work, but for some reason, I have forgotten how, and cannot figure
    it out this time.

    I'm running XP Pro. Anyone have simple directions for this?


  • middletree

    #2
    Re: Operation must use an updateable query.

    Never mind. Found answer. Problem was that in XP, defaiults selction in
    Control Panel is to have you must first turn off 'Simple File Sharing' from
    'Folder Options' to see the tab which allows you to add IUSR.


    "middletree " <middletree@HTO mail.com> wrote in message
    news:uOWol0vOEH A.1160@TK2MSFTN GP09.phx.gbl...[color=blue]
    > I recently moved my files to a new machine that I am writing my code on.
    > When I attempt to do anything to the ACCESS database through the ASP[/color]
    pages,[color=blue]
    > I get the "Operation must use an updateable query" error. I know the first
    > thing to do is go to www.aspfaq.com, and it advises me that it's probably[/color]
    a[color=blue]
    > permissions thing, and I need to add IUSR pemissions.
    >
    > Problem is, I have no idea how to do this. I thought it would be pretty
    > easy. I've added sharing permissions before for normal networking-type
    > things at work, but for some reason, I have forgotten how, and cannot[/color]
    figure[color=blue]
    > it out this time.
    >
    > I'm running XP Pro. Anyone have simple directions for this?
    >
    >[/color]


    Comment

    Working...