Using Crystal Reports via VB6

[raistllynn]

I have just converted a VB3 app to be VB6. As such, I have upgraded to crystal reports 5.

The application looks up an access database and will happily allow you to 'view' the details, but falls over when it does the report.

frm_Polinvest.rptName.Action = 1

It brings up a message box with the title "Microsoft Access Open Session" at the above line of code and has a UserID prefilled with "Admin". I've tried all the usual types of passwords (Admin, password, supervisor), but no luck.

Does anyone know if this is a standard part of crystal reports. The database opens quite happily for viewing and when opening it natively, so this is why I suspect the reports.

Thanks in advance

Elaine

 

[ohmygod]

I found a fix here :-

http://www.hammerapps.com/techtips/techtipsasp/techtipsdynamic.asp?TTID=107

 

[raistllynn]

Thank you very much for this information. I was expecting it to require a real password, not that it was some kind of corruption!

We have another platform available to try it on, which is possibly more robust and set up properly and it now works.

You are my hero!