Skip to Content
May 27, 2022 at 04:14 PM

Quick Books no Permissions


I am trying to create a new report in Crystal, and I am using Quickbooks ODBC for the data. I have finally been able to get the connection between QB and CR, but when i start working on the report i get an error that says "failed to retrieve data from database details 42000 permission denied" I generated the ODBC User in QB, and I gave it permissions to access ALL of the data sets. Any thoughts on why it thinks i don't have permissions?

QB is open under admin, and the table names show up in CR, but i cannot get the data to populate.