On Oct 26, 2:02 am, Brian Peasland <d..._at_nospam.peasland.net> wrote:
> nujcha..._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
> d...@nospam.peasland.nethttp://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 fromhttp://www.teranews.com- Hide quoted text -
>
> - Show quoted text -
Hi Brian
That was my first proposal but I thought we cuoldnt use AD to control
access to mdb. Is it acheivable? If so How???
Many thanks
Received on Fri Oct 26 2007 - 04:26:51 CDT
