If QODBC attempts an operation where the QuickBooks logged in user doesn't have the correct permissions, you will receive the status code 3260 (“Insufficient permission level to perform this action”) in the SDK Messages log. To check what permission the user has, open the company file and login as the "Admin" user and switch the company file to Single User mode:
Using the Company pulldown, select "Set Up Users..."
From the User List, edit the permissions for the user.
Check that the user has full access permission to "Purchases and Account Payable". This user (as shown below) will not see any data in the BillItemLine table.
Once you setup the permissions for the user login, you can change QODBC to use their login account instead of the "Admin" account. Go to the "Edit | Preferences" menu item in QuickBooks. Then select the "Integrated Applications" icon from the left side and follow the numbers.
|