Microsoft Access Open Session Prompt

[Former Member]

We currently use Crystal Reports 6.0 32-bit with an Access 2.0 database. When I click on the refresh button or Verify Database within Crystal, I get the Microsoft Access Open Session error that prompts for a user ID and password. I also get this error even when I access the sample reports that came with Crystal Reports. I have tried this with Crystal Reports 6.0 and 7.0 (32 bit). Any one know what the problem could be?

[Former Member]

I fixed the problem.

I had to copy an older DAO350.dll file to c:\program files\common files\Microsoft shared\DAO\ directory. This cleared up the problem. Windows XP SP2 has an DAO file that doesn't work with Crystal Reports 32 version older then version 8.

[Former Member]

HI,

Thanks for the feed back. I have uninstalled and reinstalled numerous times. Have any other ideas?

[Former Member]

Hi

It might be possible that some of the dll files have got corrupted. You can search if you have duplicate dll files of Crystal reports on the machine.

Try repairing the software from Add/Remove programs. After installation restart the application.

If that doesn't help go for a uninstall of the software and reinstall.

Regards

Sourashree