Report Manager Web Client Security Error

I am attempting to access an Access database file located on one of our
servers on the network through Reporting Services Report Manager and am
receiving the error below. I have already setup our Report Server
Service account to a domain account that has full Access to the file. I
am able to run the report from Visual Studio.Net on my local machine. I
have setup and successfully deployed numerous SQL Server based reports
and am able to run an Access based report as long as it's located on my
report server. Any help anyone could provide is extremely appreciated.
============================================== Reporting Services Error
----
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
The Microsoft Jet database engine cannot open the file
'\\Server02\PhoneBook\PhoneBook.mdb'. It is already opened exclusively
by another user, or you need permission to view its data.
----
Microsoft Reporting Services
==============================================Have you tried running it with Vis Studio closed?
I have not done this with RS, but I did have many problems connecting
asp pages to access using a DSN.
I ended up using a DSN-Less connection and it worked. I am not sure if
that is an option in RS though.
"Leo" <leo_olden@.yahoo.com> wrote in message news:leo_olden@.yahoo.com:
> I am attempting to access an Access database file located on one of our
> servers on the network through Reporting Services Report Manager and am
> receiving the error below. I have already setup our Report Server
> Service account to a domain account that has full Access to the file. I
> am able to run the report from Visual Studio.Net on my local machine. I
> have setup and successfully deployed numerous SQL Server based reports
> and am able to run an Access based report as long as it's located on my
> report server. Any help anyone could provide is extremely appreciated.
> ==============================================> Reporting Services Error
> ----
> --
> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> The Microsoft Jet database engine cannot open the file
> '\\Server02\PhoneBook\PhoneBook.mdb'. It is already opened exclusively
> by another user, or you need permission to view its data.
> ----
> --
> Microsoft Reporting Services
> ==============================================|||Thanks for your reply John. I actually did some further research and
found that the problem I'm experiencing is a known problem with Access
and the Microsoft Jet database engine. My workaround was to create a
batch file on my report server that copies in the original Access
database file to the report server every hour. My datasource now
resides on my report server and is therefore accessible.