Quick Books no Permissions

[former_member957454]

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.

[former_member11696]

Try using Administrator for the User, that works for Access files.

Access would prompt for the user and PW....

And CR 2020 is a 64 bit App so it would require a 64 bit client, that could be the problem...