Access .mdb asking for login and password in Crystal Reports.

[Former Member]

Hello Experts,

I am VERY new to Crystal reports and I am am having a Major problem running a VERY simple report.

First off I am using Visual Basic 2008 to create a Crystal Reports Application...

I am using the Report Wizard to create and the Northwind database as my database or OLE DB(ADO).

The provider I am using is the"Microsoft Jet 4.0 OLE DB Provider".

I am NOT entering a User ID or Password in the wizard and the Access file is NOT protected.

Everything seems to work fine and I can see the report in the "Main Report Preview" but when I start Debugging to see the report in the form it prompts for a User ID and Password....

If i type nothing and just hit finish it says "Logon Failed"

If i hit cancel no report is generated..

I have been messing with this for days now...

I have tried using Visual Basic 2010... Same results.

I have tried Office 2003, 2007, and 2010... Same results.

I Have uninstalled and reinstalled Visual Basic 2008...

My professor suggested this link to fix: http://support.microsoft.com/kb/888734

This does not work either... Nor do I have "Typing Tutor Deluxe" by Global Software Publishing installed...

PLEASE HELP ME so I can learn Crystal Reports!!!!

[Former Member · Accepted solution]

Please help with this!!!

I can design a Report in Crystal Reports 9...

Then Load it into VB and it works fine...

I CANNOT use the wizard in VB to design a report that works when i try to debug!!!