Re: Help please

nujcharee_at_googlemail.com wrote:
> We have a product that is based on a oracle database supplied by 3rd
> party. With the license we are not allowed to alter the database
> funny
> enough.
>
> The reports produced from this product do not fit for purpose and
> obviously we couldnt alter it due to the additional cost. So we are
> thinking to find alternatives by re designing reports in MS Access
> using ODBC to Oracle database and give users interface where they can
> enter parameter to view the reports.
>
>
> Now, from my reserach I dont think you can link Active Directory to
> MS
> Access. Is this right?
>
>
> So I am thinking "reporting service" within SQL server. I am thinking
> of having SQL Server as a shell (with no tables stored), use the
> linked server to connect to the Oracle database, SQL server can link
> with AD then finally produce a web form report.
>
>
> Am I crazy? Is it possible to do so? The main thing is that whatever
> solution, it NEEDS to use active directory for authentication.
>
>
> Anyone has better idea? Many thanks
>
>
> Peppe
>

You can create a linked table in MS Access and uses ODBC to query the Oracle data. You can then use AD to control access to the .mdb file.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com