CR8/Access DB asking for pswd when there is none

[deweese]

I am using CR8 with an Access DB (ODBC connection). My access db does not have a password. I have created a rpt in CR and it works perfect. When I run the same report from the web (using the web comp. srv.) it always asks for a db user id and password. Any advice or tips? Any help would be greatly appreciated. [sig][/sig]

 

[kenhamady]

My experience is that Crystal will ask for a password whenever it can't open the database. This might be becuase of permissions issues or corruption or a host of other reasons. In your case I would see if the web client has access to the folder containing the database. [sig]<p>Ken Hamady-

http://www.kenhamady.com<br><a

href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]

 

[medleysj]

Try using the UserID of admin and a blank password, this will probably sort out you problem, this assumes that you designed the report using the odbc driver that you are trying to refer to.

If you designed the report using access drivers and are trying to open it with an odbc connection it will never work.

Steve