CE85 Pro: MS Access reports asking for password 2

[vey99]

Hi there,
We are implementing CE85 Pro, and are doing some reports that connect to MS Access 97 database via network.

We mapped the drive, and created a System DSN to the file.
During report design in CR85, we could preview the report.

When we put the report into CE, it prompts for username/password.

Will greatly appreciate if anyone has seen this before.

FYI I have checked the similar post in Jun 02 but the solution wasn't applicable here.

 

[Lochbel]

Suggest several possibilities:
a)Ensure DSN uses UNC path convention, or
b)Check CE Job/Server have correct access rights to network (not necessarily the local account)

 

[tmobile]

I believe the problem may be in your ODBC linking.
I would delete the ODBC and set it up again making sure to use the Access ODBC supplied with Crystal Designer. Make sure that each step in the ODBC linking is done correctly.