Connect to secure database?

[ana9 via AccessMonster.com]

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?

 

['69 Camaro]

Hi, Ana.

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"

Actually, that's not a connection string. It's the command line command to use
Access to open the Access database file with a particular workgroup file. (It
can be used in a Windows shortcut.) The following are what a connection strings
looks like (the first is all one line):

Driver={Microsoft Access Driver
(*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;

or:

Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;

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.

Actually, you don't get redirected. Access checks the workgroup information
file for authentication and if successful, the database file is opened.

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

You should post this question in a newsgroup for reporting services, because you
now have the connection string information (at least the syntax, and you can
replace the place holders with real paths and file names). Many applications
use Access as the data source, but asking how to use one of those applications
in an Access newsgroup isn't the fastest or best way to get correct answers.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

 

[ana9 via AccessMonster.com]

Thanks for taking the time to explain all that. I just had to put the
SystemDB part into my connection string in Reporting Services and it works
great.

 

['69 Camaro]

You're welcome, and thanks for sharing that you were successful and how you did
it. It will probably help someone else in the future.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.