Connect to secure database?

I am trying to connect to an access database through reporting services to
generate some good looking reports.

The connection string for the database on my desktop is as follows:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "f:\sales order
database\asiso1.mdb" /WRKGRP "f:\sales order database\Secured.mdw"

In order to allow multiple people to access the database at the same time I
have to login to the secured.mdw first, which finds my login/pwd and
redirects me to the actual asiso1.mdb database.

How can I connect to the database through reporting services with this
configuration?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200612/1

.

Relevant Pages

  • Re: Syntax
    ... The connection string format is not valid. ... connection string with zero components is set on database connection manager. ... Access database connection string, and not the Expression issue you're ...
    (microsoft.public.sqlserver.dts)
  • Re: DateCreated
    ... > Access database. ... you haven't indicated what breaks or what error you get when you change the connection string and any code ...
    (microsoft.public.vb.database.ado)
  • Re: side by side migration sql 2000 to sql 2005
    ... Thanks Andrew, I am scheduling myself some serious study time. ... Andrew J. Kelly SQL MVP ... I performed an inplace upgrade and my SQL Database upgrade went ... Reporting Services and then Installing Reporting Services 2005. ...
    (microsoft.public.sqlserver.setup)
  • Re: Web Services and Access databases
    ... How To Retrieve and Display Records from an Access Database by Using ... When I press the Test Connection button it ... the same code with the same connection string works for Windows ...
    (microsoft.public.dotnet.framework.webservices)
  • Help! Microsoft Access 2003 issue with linked tables.
    ... I have a Microsoft Access database and tables are linked to the SQL Server ... I use that SQL user in my connection string, ...
    (microsoft.public.access.security)