• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 405
  • Last Modified:

Crystal reports asks for password when connecting to Access 2007 database

Hello. I have saved an access file from a sharepoint site and am trying to connect to it via Crystal reports. The report was already developed on another system using that access file.
For some reason, Crystal keeps popping up this RDO (ODBC) Connection information screen with a username/password box. Any ideas on why this might be? I tried to set the access file as a datasource in the control panel trying both System and File DSN. This does not happen on another computer in the office that already had this setup.

Any ideas on why this occurs? We also tried on the same database file that was not loaded from sharepoint and got the same error, so I doubt sharepoint has much to do with it. Thanks all.
0
dprasad
Asked:
dprasad
  • 2
1 Solution
 
mlmccCommented:
Do you have the MS Office 2007 ODBC database drivers loaded?
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734

Crystal doesn't have the native connectionmethod until CR 2011.
You have to use ODBC to connect to an accdb file.

mlmcc
0
 
mlmccCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now