<div>
I think that it is easier to change your ODBC settings than your database location.<br />
<br />
One easy way to change your ODBC settings is to use the RegisterDatabase method (found in DAO).
</div>


I think that it is easier to change your ODBC settings than your database location.

One easy way to change your ODBC settings is to use the RegisterDatabase method (found in DAO).

<div>
Are you talking about changing the title from 'Oracle database'<br />
to 'MSAccess database'?<br />
<br />
Are you using the Report Design Component?<br />
<br />
Are you asking for the VB code to change the location from Access to Oracle?<br />
<br />
All of these are possible, but I'm not sure which one to answer.
</div>


Are you talking about changing the title from 'Oracle database'
to 'MSAccess database'?

Are you using the Report Design Component?

Are you asking for the VB code to change the location from Access to Oracle?

All of these are possible, but I'm not sure which one to answer.

<div>
I'm looking for the VB code to change the ODBC connection... i've been trying the whole day long without success.<br />
<br />
I've been changing the Connect propery for the Crystal Reports control, but it just doesn't work
</div>


I'm looking for the VB code to change the ODBC connection... i've been trying the whole day long without success.

I've been changing the Connect propery for the Crystal Reports control, but it just doesn't work

<div>
<div class="content wysiwyg-content">
Hi experts.<br />
<br />
I have a report, designed with crystal Reports. This report has been designed using an ODBC connection, using some tables on an ORACLE server. However I have an MS Access (.mdb) database with the same tables.<br />
I need to change the connection at runtime, so, depending on the user's selection, the report should read either the Oracle database or the MSAccess database..... <br />
<br />
Is this possible?
</div>
</div>


Hi experts.

I have a report, designed with crystal Reports. This report has been designed using an ODBC connection, using some tables on an ORACLE server. However I have an MS Access (.mdb) database with the same tables.
I need to change the connection at runtime, so, depending on the user's selection, the report should read either the Oracle database or the MSAccess database..... 

Is this possible?

Crystal Reports DB problem

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.