SAP Knowledge Base Article - Preview

2397203 - Set Location to a MDB database file using relative path up one folder - ..\Access.mdb does not work

Symptom

The issue we are having is since updating to 13.0.17, we are unable to change the connection information on the report using the method SetConnection.

This is not an issue on every report. From my investigation, it appears to happen on reports with a large number of sub reports.

The report is designed using relative pathing to the MDB file. In CR DEsigner you will see the path showing like this:

..\Access.mdb

What this should do is redirect the Database engine to move up one folder from the EXE in .NET Application and find the database file in that folder.

When attempting to do so it pops up a message indicating the database cannot be found or if viewed it will continually prompt for log on info.

NOTE: if it is a secure Access MDB file it will continually prompt for User name and password.


Read more...

Environment

Crystal Reports for Visual Studio SP 17 and SP 18

Product

SAP Crystal Reports, developer version for Microsoft Visual Studio

Keywords

crystal reports, relative path, ..\access.mdb, cr for vs, crystal reports for visual studio, prompt for log on info , KBA , BI-RA-CR-SDK , SDK related, including Java/.NET etc. , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.