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?

Solutions:

• 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.
  
  

OR

• 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