We are writing to QuickBooks safely.
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