Access: 004 : Operation must use an updatable query

Access: 004 : Operation must use an updatable query

Cause:
The cause of this issue is that the logged in Window's user does not have permission to access the GLOBODOX Databases folder. You can follow the below steps to provide permission for Windows User's on the GLOBODOX Databases folder.

Solution:

Scenario 1:

Step 1:

Sharing the folder
  • Go to to the GLOBODOX Databases folder, by default it is located in C:\GLOBODOX Databases. Right-click the 'GLOBODOX Databases' folder and click on Properties.
  • Click on the Sharing tab. From the Sharing tab, click on the 'Share' button.
  • Select the Windows users from the drop-down list and click on the Add button.
  • Select the Permission Level for each of these users. It is recommended to provide 'Read/Write' permission for all the user's. 
  • Click on the Share button.
Step 2:

Providing Share permissions

  • Right-click the 'GLOBODOX Databases' folder and click on Properties tab.
  • Click on the Sharing tab. Click on the 'Advanced Sharing...' button. The Advanced Sharing dialog will be launched.
  • Click on the 'Permissions' button. Now add the Windows users and give the user 'Full Control' permission.
  • Click on OK. Click on OK again to close the Advanced Sharing dialog.

*Note : In case, the above steps does not resolve the issue; then most likely the user does not permission to access the Folder and Files in the GLOBODOX Databases folder. You can follow the below steps to resolve this.

Scenario 2: 

Files & Folders in the GLOBODOX Databases Folder do not have permissions for Windows user

Steps:
  • Close GLOBODOX. Browse and open the GLOBODOX Databases folder from Windows Explorer.
  • Right-click on 'MainDB' folder and select Properties.
  • Navigate to Security Tab and check if the Windows user has modify permission on the MainDB folder.
  • Right-click on 'MainDB.gxdb' file and select Properties.
  • Navigate to Security Tab and check if the Windows user has modify permission on the MainDB.gxdb file.



    • Related Articles

    • Access : 005 : Could not use file already in use

      Error Message:             ErrorCode: 61443             Message:Failed to connect to database 'MainDB.gxdb'.              (ErrNo:-2147467259 Details:Could not use ''; file already in use.) Cause: From the error it seems that the currently logged in ...

    • Migrate GLOBODOX v10 MS Access DB

      Step 1: Backup DB on old machine Follow instructions from the link below to take a backup of the MS Access DB... https://www.globodox.com/support/help/index.htm?backup_a_ms_access_based_db.htm Note: Make sure you take a backup of all the DBs. Move ...

    • Use Google SMTP via App Passwords after enabling 2FA in your Google Account

      Introduction For users of GLOBODOX who use Gmail as their SMTP server, enabling two-factor authentication (2FA) can lead to issues where GLOBODOX is unable to send emails using the existing credentials. To resolve this, you need to create an App ...

    • Access: 002 : The search key was not found in any record

      Cause: By default, GLOBODOX uses a MS Access based DB to store data and documents. If there are any connectivity issues when using the DB over the network/Wi-Fi, the DB may get damaged (as the DB connection is lost abruptly while modifications are ...

    • SQL: 002 : SQL Server does not exist or access is denied

      Error Message: ErrorCode: 61443 Message: Failed to connect to database 'MainDB'. (ErrNo:-2147467259 Details:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.) Cause: The error indicates that GLOBODOX is unable to ...