Skip to Content
0
Former Member
Oct 18, 2012 at 10:12 PM

VS 2010/CR accdb fails on password entry

75 Views

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?

Help!

Bill