I am supporting an Access XP (2002/2003) vba application and my client has requested integration with Crystal Reports XI Release 1 SP4.  They would like for the app to list in a grid, all available Crystal Reports and provide a user the ability to double-click and launch the report viewer.

 

Sounds simple, right?  I'm certain I can do this in Access but I'm having a great deal of difficulty.  Whenever I go to launch a report the message "Failed to Open The Connection" is displayed.  This message is displayed on target machines that do not have a XI designer installed.  On those machines, I have installed a runtime package that blows on the runtime components of Crystal 11 RDC as defined in the merge modules  CR11_RDC:  _Designtime, _License, _ReportEngine, and _Runtime

 

The code is very simple:  Dim crwApp as New CRAXDRT.application, Dim crwRpt as CRAXDRT.report, crwApp.logonServer (with all the correct parameters)

 

I think I'm missing something really obvious.  Can anyone please send me some things to look at?  I've been at this all day and I just don't know what's wrong!

 

Thank you,

 

george H. 

 

p.s., Duh, the backend database is sql server express 2005.  When I built the report I used RDO to connect to the database.