Calling Crystal reports through VBA, OK with 8 problems with 7

[OzzieOwl]

I have written some vba code that calls crystal a report, fills the Edit Select Formula runs and exports the results to Excel, it all works perfectly when run on a machine with Crystal 8 installed, but when I run it on a machie with Crystal 7, I keep getting "Unable to log into server". I have changed all the references to the Crystal 7 libraries, but still have the same problem. Has anyone got any suggestions on how to fix it, I can supply the VBA code if that will help.

Thanks

Ozzie

 

[Fursten]

Hi,

Maybe the driver that comes with CR7 for that database as some bun on it. Are you accessing an Access database? I read something about a problem in Access2000 drivers. Search in

http://www.crystaldecisions.com