Error: operation must use an updateable query
After making the set up of the application(developed using VS 2008 and M开发者_如何转开发S Access) the installation in another system works fine. But whenever I try to change the Password or id(there is a login window which the user need to access to get into the main window) it shows an error sayin "operation must use an updateable query". Can anyOne suggest the remedy?
Thank you, Indranil
Have you checked the permissions are the same for both set-ups? You will need a minimum of read and write permissions on the folder that contains the Access file.
To check permissions, it may be possible to right-click on the file or folder and choose Properties. The Security tab will show the details.
For web applications, you need to check the permissions for IUSRS.
- To fix this error, you need to run your application in Administrator Privilege
- Do the following steps to run the application in Administrator Privilege
Change Level From
<requestedExecutionLevel level="asInvoker" uiAccess="false" />
To
<requestedExecutionLevel level="requireAdministrator" uiAccess="false" />
It is available in UAC settings, located in the Project Settings
精彩评论