[QODBC-Desktop] Writing to QuickBooks safely / Always connect in Read Only Mode
Posted by Jack - QODBC Support on 19 August 2015 02:13 PM

We are writing to QuickBooks safely.

Problem Description:

I'm a little concerned about the write feature and changing any current data in QuickBooks from the Excel files I want to experiment in. Are my concerns valid, or what is the best way for me to prevent that from occurring?


  • Updating any record in the Excel sheet will not fire the update command or change anything on QuickBooks (unless using VBA script). For better security, you can enable the "Read-Only Access" feature from the QODBC Advanced tab to avoid any application using QODBC to Write to QuickBooks.

You can disable write permission by enabling the "Read-Only Access" options from:

Start>>All Programs>> QODBC Driver for use with QuickBooks>>QODBC Setup Screen>>Advanced Tab>> Enable the "Read-only access" option. & apply the changes.

  • You can make a copy of the company file and test it. So your original company file will be safe.


  • You can take a backup of company files & restore them whenever needed.

  • QODBC does not write to the QuickBooks company file directly; QODBC writes through the QuickBooks SDK, which follows all business rules & validation.


Tags: configurations, permissions, user rights

(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).