Access db with password

[crogers111]

CR XI & BOe XI
ADO

I've published a report that pulls data from an Access DB.
The DB resides on a different machine than BO and has a DB password. For the DB Logon info, the Server Name and Database Name are set as:

\\SERVER\databases\data.mdb

when trying to run the report I get the error message in the failed instance:

'Unable to connect: incorrect log on parameters.'

BO has input boxes for User ID and Password so I'm unsure how this works as I only have a db password (have tried leaving User ID blank)

I tried with the server name only the unc path to the database (as opposed to the full path for both) but get and error that makes me think the full UNC path for both is correct and that it's a problem with permissions or User ID/Password:

The database logon information for this report is either incomplete or incorrect.


I've read some posts on making sure the 'account the CE Services are setup with have file access'

If this is where I should be concentrating, I'm unsure:

1. How do I determine which account the Services were setup with ?
2. Which services do I need to check ?
i see 3 Crystal Report Services: Cache Server, Job Server, Page Server all set with "Log on as Local System Account"

Note: Other report pull from a SQL db on the same server as BO OK.

Any additional info or ideas are appreciated !!!!!

 

[synapsevampire]

Why are you using ADO?

And you should know the user name, perhaps it's Administrator.

Anyway, a standard ODBC connection should work fine, but you need to know the user name.

-k

 

[crogers111]

Typo, Sorry...I meant Excel/Access DAO.
The report runs fine with this connection outside of BOe

There is no user name. This is an access db with a database password no user level security(i.e. you dbl click the .mdb file and it prompts you to enter the db password)

Trying the ODBC Connection, but can't even get it setup just with Crystal...

In the 'Data Source Selection' Screen there are many options to select including MS Access Database when the 'Select Data source' radio button is selected (but doesn't let me browse to my specific file on the network) on the next screen it prompts for user ID and password and I don't have a User ID since it's a db password

back on the 'Data Source Selection' screen I select the radio button: Find File DSN, which allows me to browse and actually locate the .mdb, but the next screen after location my file also has boxes for User ID and Password and fails with any attempt

I did try administrator as the User ID just to see, but no luck, left User ID blank, put the password in both boxes, all return Logon Failed message.