When launching the Payment Terminal, users may receive an error with the text "Operation must use updateable query" and be unable to launch the program. This most-often happens in a multi-user environment (either a shared workstation, or a server environment).
This is caused by a permissions issue on the Payment Terminal's configuration folder. We use a couple of databases to store program configuration, as well as some log files and temporary directories, to store information about the Payment Terminal environment (including QuickBooks company file, list of Customers in QuickBooks, and list of transactions that were previously processed). These files, and their containing folder, must allow read/write access from the Everyone security group, as the database client may run under a special user context for security purposes.
This can be fixed by correcting the security settings for the configuration folder.
To reduce possible permissions issues, it's recommended that you complete these steps from an admin user on the computer.
1. Open the
%PROGRAMDATA%\Payment Terminal folder.
Open the Run dialog by pressing WIN-R (or clicking Run in the Start Menu). In the dialog that appears, paste in
%PROGRAMDATA%\Payment Terminal and press Enter. This should open the Payment Terminal configuration folder.
2. Allow the
Everyone security group read/write access to all files/folders.
There are a few different items that need to have their security settings changed in this folder, so applying the settings to all items in the folder is the recommended option. Right click on a blank space in the folder, and click Properties. In the Properties window that appears, click the Security tab at the top. If present, click the Edit button, and then select the
Everyone security group from the selection at the top. Make sure that Full control is checked, and click the OK button.
3. Relaunch the Payment Terminal.
Reopen the Payment Terminal - it should open as normal.