|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
can't run report from crystal reportsI'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. On Mon, 17 Jul 2006 06:41:02 -0700, Tami <T***@discussions.microsoft.com> wrote:
>I'm trying to run a crystal report from an access database. 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> >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. 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. Show quoteHide quote "Tami" wrote: > 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. On Tue, 18 Jul 2006 05:41:01 -0700, Tami <T***@discussions.microsoft.com> wrote:
>It allows me to connect to the database to the point where I can see the Apparently the login you're using doesn't have permissions to view the query or table(s) driving the query.>tables. However, when trying to select the tables that is when I get this >error. > Can you open the db directly? If so, can you view the query directly? Show quoteHide quote >"Tami" wrote: 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. >> >> Please Help. scott@takemeout_infotrakker.com www.infotrakker.com yes i can log in and view tables and queries directly.
Show quoteHide quote "Scott McDaniel" wrote: > On Tue, 18 Jul 2006 05:41:01 -0700, Tami <T***@discussions.microsoft.com> wrote: > > >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? > > > >"Tami" wrote: > > > >> 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. > > Scott McDaniel > scott@takemeout_infotrakker.com > www.infotrakker.com > On Tue, 18 Jul 2006 08:56:02 -0700, Tami <T***@discussions.microsoft.com> wrote:
>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 
Other interesting topics
Access-New User-Help!!
Security nightmare - 2 mdw's mixed up Digital Certificate for runtime installs. (Not Self Cert) Network Security multiple users, Getting rid of the warning messag corrupt files deleting microsoft access user passwords log on screen in Access? Programatically hide and unhide the database window Disable Security - Use the standard .mdw file - Allow external apps to connect using DAO Reopen the database for relogon |
|||||||||||||||||||||||
