Not sure if this is the right area but her goes

 

I have an Access 2007 database with an ActiveX control embedded in it: -

 

Crystal ActiveX Report Viewer Control 11.0

CrystalReports11.ActiveXReportViewer.1

 

The problem is that for one report it will open the .rpt fine but for another identical one it will not. There are two reports one cloned from the other giving the same fields etc but each from a different table, one for 2009 and one for 2010.

 

If I open the database and try to open the 2010 report first I get this error: -

 

An error occurred number: -214718176 and description: Logon Failed

 

However if I open the 2009 report first then the 2010 will open and work fine, they both use exactly the same module to open the crystal report the only difference being it is fed a different SQL view name to use. Both Views are the same except one says 2010 and uses a separate 2010 table which is a clone of the 2009 one.

 

I am new to crystal reports so I am at a loss and any thoughts welcome.

 

Thanks