Access 2003 and Crystal Reports 9 - Database Password error

[WindSailor]

Upon choosing the Crystal Reports Wizard in the add-in's Tools Option in Access, the CR wizard opened promptly, asked which table or query to make reference to... I selected a particular table and then I was prompted for a database password... for which I have none administered for that database.
After failing to provide the correct password I get the following error.

-----------------------------------------------------------------------------------
"Microsoft Access can't find the wizard, or the wizard has not been installed, or there is a syntax error in the Declarations section of a Visual Basic module."
"The Wizard you need may be missing from the libraries key of Microsoft Office Access section of the Windows registry, or the wizard has been disabled."

The last paragraph (which I didn't include) states to re-install Access and check to see if the wizard is disabled.

-----------------------------------------------------------------------------------
I went back and checked the module I have for protection and verified that there was no database protection. I also checked and there were no disabled options in MS Access, and re-installed MS Office, all with no success.

I simply can't get Crystal Reports to run inside of MS Access 2003.

This isn't an isolated incident with Access and Crystal Reports and is posted on other forums on the web as well with no clear resolution or simply no responses at all that I can find so far (there is one that is listed for CR 8.5 but not for CR 9). So I apologize for relisting it but maybe someone could help me and others that have the same problem. If I do find a resolution, I will post it here.

Thanks
Rick

 

[WindSailor]

Another Option

This Microsoft Access sample demonstrates how to integrate the Report Designer Component (RDC) with Access VBA. This sample is for use with Crystal Reports 8.5 and higher.

http://support.businessobjects.com/communityCS/FilesAndUpdates/rdc_vba.exe.asp

 

[WindSailor]

Drivers that will support CR 7 to work with Access 2000

Drivers that will support CR 7 to work with Access 2000

http://support.businessobjects.com/communityCS/FilesAndUpdates/access2000drivers.zip.asp

 

[WindSailor]

Well... Access 2003... isn't supported.

Supported and tested platforms for CR 9:

http://support.businessobjects.com/library/kbase/articles/c2011814.asp

BusinessObjects said that they would make a best effort to resolve issues concerning Access 2003.

And the new "Crystal Reports 10" has been released.

 

[ChickeyD]

Crystal ActiveX (OCX) control in Access

This Microsoft Access sample demonstrates how to integrate the Report Designer Component (RDC) with Access VBA. This sample is for use with Crystal Reports 8.5 and higher.

http://support.businessobjects.com/communityCS/FilesAndUpdates/rdc_vba.exe.asp

This sample works great. However, I am unsuccessful at getting this to work in my database. I'd like to try and build (so I'll know how) but I haven't a clue where to begin.

I've tried the more controls on with form toolbar and have been successful at inserting a Crystal Report Viewer...but it's just a plain window within a form. Help! Anyone have any ideas on how I can either get this sample database referenced above to work in my application or on how I can build one myself?

All this because I have yet to find a way to have a query calculate the number of days between two dates and exclude holidays and weekends. I was able to do this in Crystal Reports quite nicely. So thought I could have the end user pull up this report using the Crystal Reports Viewer.

I do have some experience with Access, but not a lot. Thanks =)