can't run report from crystal reports

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

Scott McDaniel

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
 
G

Guest

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

Scott McDaniel

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
 
S

Scott McDaniel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change a table owner 1
Can't create a report from my query in Access 1
Crystal Reports Version 11 0
Crystal Report SQL Conversion 1
DAO Error Code: 0xbeb 5
Pass changing values to parameter to Crystal Report scroll thru re 3
invalid report file path 0
Unable to read DB - Locked Link Table 1

Top