can't run report from crystal reports

[Tami]

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.

 

[Tami]

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.

 

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

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

 

[Tami]

yes i can log in and view tables and queries directly.

 

[Scott McDaniel]

yes i can log in and view tables and queries directly.

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