Amphis Software Tech Tips |
|
|
|
|||
Home Page Sitemap CRM Software Quick Guide Free Web CRM Software - Free Web Access to Customer Details Download FREE 30 Day CRM Software Trial
You may see the error "Operation must use an updateable query" when trying to update a record in a Microsoft Access Database.
The user has to have the relevant permissions in order to be able to Insert or Update a record in an Access Database. In a single user app, this error can just mean that the user does not have Insert or Update permission to create/update a record in the Microsoft Access Database. This may, for example, be because the Access Database is in the C:\ drive on Windows Vista, for example, where by default, the user would not be able to update the database. In an IIS scenario, the problem can be that the account running IIS does not have access to update the database. In a multi-user network scenario, an .ldb file is created to prevent one user updating a record locked by another user.
In a single-user environment, you may just need to move the Access Database to somewhere where the user does have permission to insert/update records eg the Documents folder. Or you can change the security of the file itself to allow the user to insert/update records. For an IIS scenario you need to determine who IIS is running the code as and change the security of the file to allow that access. For a multi-user network scenario, you may need to consider locking rows rather than entire pages to reduce the chance of one user being locked out by another user.
Home Page Sitemap CRM Software Quick Guide Free Web CRM Software - Free Web Access to Customer Details Download FREE 30 Day CRM Software Trial
