Connect SSRS to MS Access db that has User-Level Security

Hello Everyone,
I have an Access database that i set up some time ago and that is still in
use by employees. The database was set up using user-level security. The
database is seperated, one- the "back end", named **be.mdb- housing the
tables and some queries. The other- **.mdb- has all the forms, modules and
other queries. The back end is on a shared file server, and each user has the
front end on thier local machine.
I use the Report Wizard to setup the data source connection, which is ODBC,
and permissions. I can preview it in Report Designer fine. Once the report is
published to the Report Manager however, I get an error telling me that no
connection to datasource can be established because either i have no
permissions, the workgroup information file can not be found or someone else
is using the file.
When I setup up the dsn, i made sure to include the WIF in the string- named
secure.mdw. However I'm stumped as to my failure to connect. Can anyone give
me some guidance on how to properly setup connection from SSRS to an Access
datbase that has user-level security?
Many thanks.I'd just move it to SQL Server.. Honestly; I've been through a ton of
migrations over the years-- moving to SQL Server _NOW_ instead of
later can save you a lot of headaches.
I mean.. the front end ; it should be easy to move to an Access Data
Project-- simplify the database side before worrying about the
reports.
-Aaron
On Mar 21, 1:49=A0pm, Damon Johnson
<DamonJohn...@.discussions.microsoft.com> wrote:
> Hello Everyone,
> I have an Access database that i set up some time ago and that is still in=
> use by employees. The database was set up using user-level security. The
> database is seperated, one- the "back end", named **be.mdb- housing the
> tables and some queries. The other- **.mdb- has all the forms, modules and=
> other queries. The back end is on a shared file server, and each user has =the
> front end on thier local machine.
> I use the Report Wizard to setup the data source connection, which is ODBC=,
> and permissions. I can preview it in Report Designer fine. Once the report= is
> published to the Report Manager however, I get an error telling me that no=
> connection to datasource can be established because either i have no
> permissions, the workgroup information file can not be found or someone el=se
> is using the file.
> When I setup up the dsn, i made sure to include the WIF in the string- nam=ed
> secure.mdw. However I'm stumped as to my failure to connect. Can anyone gi=ve
> me some guidance on how to properly setup connection from SSRS to an Acces=s
> datbase that has user-level security?
> Many thanks.