Using Crystal Reports (13.0.4) for VS 2010, I create a report for a .accdb with a password. I use OLE DB then select MS Office 12.0 Access Database Engine to establish a connection during the report creation. The next dialog asks for the file location, I leave Office Database Type blank, leave "Admin" as the User ID and enter a password under "Password". After I click "finish", I receive the error "...workgroup information file is missing...".
I have searched the discussions and tried all the suggestions. Here is what is interesting about this situtation:
1. Remove the password using Access. Now create the report - everything works perfectly!
2. Use access and reaply the password. Now open the report of step 1. A dialog appears asking for a password. Enter the password and get the error message mentioned earlier! The PROBLEM seems connected to the PASSWORD only.
3. Using a connection string and VS 2010 without Crystal Reports, the same database can be accessed without a problem. The connection string that works is:
Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\folder\file.accdb;Persist Security Info = false;Jet OLEDB:Database Password=passwd
I think there is a bug in Crystal Reports for VS Studio when a password is given for .accdb files?