"IJ Singh" wrote:

> Thanks for the pointer. I will look the article up.
>
> "Oleg Yevteyev" wrote:
>
> > There is an article
> > http://support.microsoft.com/default.aspx?scid=kb;EN-US;q306269
> > Have you tried all the steps?
> >
> > --------------------
> > Oleg Yevteyev,
> > San Diego, CA
> > It is OK to contact me with a contracting opportunity.
> > "myfirstname"001atgmaildotcom.
> > Replace "myfirstname" with Oleg.
> > --------------------
> >
> > "IJ Singh" <IJSingh@discussions.microsoft.com> wrote in message
> > news:DEBF93DC-49D5-4C54-824D-3B4B8922AA28@microsoft.com...
> > >I have allready tried that. Does not help
> > >
> > > "Oleg Yevteyev" wrote:
> > >
> > >> Try to grant full access to the mdb file(s) to EVERYONE. Fine tune it
> > >> later.
> > >>
> > >> --------------------
> > >> Oleg Yevteyev,
> > >> San Diego, CA
> > >> It is OK to contact me with a contracting opportunity.
> > >> "myfirstname"001atgmaildotcom.
> > >> Replace "myfirstname" with Oleg.
> > >> --------------------
> > >>
> > >> "IJ Singh" <IJSingh@discussions.microsoft.com> wrote in message
> > >> news:0DD2C470-1FCB-4790-842E-728241033CF0@microsoft.com...
> > >> > Oleg,
> > >> >
> > >> > The reports use an ODBC connection and the Exclusive check box is
> > >> > unchecked
> > >> > on this ODBC data source. And the MS Access environment is also closed.
> > >> >
> > >> > But I still get the same error
> > >> >
> > >> > "Oleg Yevteyev" wrote:
> > >> >
> > >> >> I must be using an ODBC data source for your access database.
> > >> >> In ODBC data source click on "options" and uncheck "Exclusive" check
> > >> >> box.
> > >> >> It that simple.
> > >> >> If it is unchecked - just close any MS Access environment prior to
> > >> >> running a
> > >> >> report.
> > >> >> --------------------
> > >> >> Oleg Yevteyev,
> > >> >> San Diego, CA
> > >> >> It is OK to contact me with a contracting opportunity.
> > >> >> "myfirstname"001atgmaildotcom.
> > >> >> Replace "myfirstname" with Oleg.
> > >> >> --------------------
> > >> >>
> > >> >> "IJ Singh" <IJSingh@discussions.microsoft.com> wrote in message
> > >> >> news:F0AEC822-C663-4A64-8D32-F4B8F0C2A418@microsoft.com...
> > >> >> >I have the following set up installed
> > >> >> >
> > >> >> > 1. IIS1 server with Reporting Services.
> > >> >> > 2. IIS2 server with Reporting Services
> > >> >> > 3. Access Db on a third machine.
> > >> >> >
> > >> >> > I have created some simple reports in Reporting Services which
> > >> >> > connect
> > >> >> > to
> > >> >> > the Access Db. I can run this reports from the Report Manager if I
> > >> >> > login
> > >> >> > to
> > >> >> > either IIS1 or IIS2 and call the report manager from the respective
> > >> >> > server.
> > >> >> >
> > >> >> >
> > >> >> > Reporting Services Error
> > >> >> > --------------------------------------------------------------------------------
> > >> >> >
> > >> >> > An error has occurred during report processing.
> > >> >> > (rsProcessingAborted)
> > >> >> > Get
> > >> >> > Online Help
> > >> >> > Cannot create a connection to data source 'DataSource2'.
> > >> >> > (rsErrorOpeningConnection) Get Online Help
> > >> >> > The Microsoft Jet database engine cannot open the file
> > >> >> > '\\AccessDbServer\c$\Program Files\actiTIME\database\actitime.mdb'.
> > >> >> > It
> > >> >> > is
> > >> >> > already opened exclusively by another user, or you need permission
> > >> >> > to
> > >> >> > view
> > >> >> > its data.
> > >> >> >
> > >> >> > Can anyone out there help me resolve this issue.
> > >> >> >
> > >> >> > Regards
> > >> >> >
> > >> >> > But I get the following error if I run the reports from the Reports
> > >> >> > Manger
> > >> >> > on IIS2 while I am logged in to IIS1.
> > >> >> >
> > >> >> >
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >