Operation must use an updateable query

If you’re getting an error when Inserting or Updating an MS Access Database (‘Operation must use an updateable query’), that’s because the ASPNet user account needs the correct permissions on the directory where the database resides
To fix this in Windows 2K:
(Go into Accessories/Computer Management/Local Users & Groups/users
You will see that there’s an ASPNet user. )

Right click on the directory where your database is – choose properties – Then the security tab – then click on permissions.
Add the ASPNet user to the shared section
Then, make sure it has ‘Change’ rights –
Click Apply and you should be working fine then

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>