can't run report from crystal reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to run a crystal report from an access database.

When trying to select any table from this database as the data source I get
the error:

Query Engine Error: 'DAO Error Code: 0xC26 Source: DAO.Fields
Description: Could not read definitions; no read definitions permission for
table or query '(1)School Info'.'

I suspect that it has something to do with the security of the database.

Please Help.
 
I'm trying to run a crystal report from an access database.

When trying to select any table from this database as the data source I get
the error:

Query Engine Error: 'DAO Error Code: 0xC26 Source: DAO.Fields
Description: Could not read definitions; no read definitions permission for
table or query '(1)School Info'.'

I suspect that it has something to do with the security of the database.
Click to expand...

You should be able to set the Connection info in your CR program. I use CR11 (and hate it, by the way, but all my
corporate clients use it) and I can define the connection parameters in the Database - Set Datasource location. If
nothing else, you can use the Create new Connection. Note these terms may be different with older versions of CR ...


Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
It allows me to connect to the database to the point where I can see the
tables. However, when trying to select the tables that is when I get this
error.
 
It allows me to connect to the database to the point where I can see the
tables. However, when trying to select the tables that is when I get this
error.
Click to expand...

Apparently the login you're using doesn't have permissions to view the query or table(s) driving the query.

Can you open the db directly? If so, can you view the query directly?


Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
yes i can log in and view tables and queries directly.
Click to expand...

Are you sure you're using the same login with your Crystal Reports? Sounds as if you're logging in with a different
username/pass combo ... or you haven't specified the correct workgroup file to CR ...

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
Back
Top