Re: Access 2000 reports: sql view does not exist
aaron_kempf_at_hotmail.com
Date: 03/01/04
- Next message: aaron_kempf_at_hotmail.com: "Re: Keep data from previous record in a DAP"
- Previous message: aaron_kempf_at_hotmail.com: "Re: Performance tips - Rookie"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 1 Mar 2004 14:37:29 -0800
yeah it sounds like an 'ownership problem'
"Timo" <timo@anonymous.com> wrote in message
news:O7GQ5Zw%23DHA.2512@TK2MSFTNGP11.phx.gbl...
> I have a mysterious situation that maybe someone else here has seen and
> knows how to fix. A user can log into Query Analyzer (using Windows
> Authentication) and can issue this command:
>
> select * from viewTest
> [as the name suggests, viewTest is a view]
>
> and get correct results. But when the same user attempts to run an Access
> report which uses viewTest as its datasource, there is an ODBC error
saying
> that the object does not exist.
>
> The ADP is using Integrated Security. Other forms are working fine. I
have
> dropped the view and recreated it. I have also created a second view and
> based a report on it and it too fails with the same error. The test
reports
> were built using the Wizard and the view used as the datasource was
selected
> from the dropdown.
>
> NOTE: SQL Trace shows *no* activity when the user attempts to launch the
> report. But if the user opens up a form that goes against a table, that
> SELECT activity IS visible in SQL Trace.
>
> Note also: sys admins are able to run the same Access report without any
> problem.
>
> Any help solving this mystery is appreciated.
>
> Thanks
> Timo
>
>
- Next message: aaron_kempf_at_hotmail.com: "Re: Keep data from previous record in a DAP"
- Previous message: aaron_kempf_at_hotmail.com: "Re: Performance tips - Rookie"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
