<div>
13 - O long as you linked to it and didn't import it, the data should be live<br />
<br />
Are you getting an error?<br />
<br />
At firt you are saying linking MS SQL to Access and then at the end you say Oracle to Access<br />
Which is it?<br />
<br />
mlmcc
</div>


<div>
Yes I'm getting the crw32.exe fatal error. &nbsp;Here's the setup. &nbsp;You helped me with it in a prior question. &nbsp;I need to incorporate a SQL data source table with an Oracle table. &nbsp;The suggestion was to link the SQL table in Access and then link to Oracle. &nbsp;It should work, but it doesn't.
</div>


<div>
I'm not sure it's clear what you are ultimately trying to do...<br />
<br />
You are using Crystal Reports to report on something right? &nbsp;I don't think you can have CR use a linked table from within Access so that is a problem. &nbsp;<br />
<br />
Can't Crystal reports access ODBC data itself (in other words report directly on the Oracle data through ODBC)?
</div>


<div>
I think you may have to link inside Access to both MS SQL and to Oracle.<br />
<br />
mlmcc
</div>


<div>
I searched for SACommonControls.dll and found it in 2 places.<br />
<br />
C:\Program Files\Business Objects\Common\3.5\bin &nbsp; &nbsp; &nbsp; modified 9/16/2010<br />
<br />
C:\Program Files\Common Files\Business Objects\3.0\bin &nbsp; &nbsp;modified 7/27/2005<br />
<br />
Where should it be? &nbsp;Should I have 2 dlll's?
</div>


<div>
I did what you suggested and received the message DllRegisterServer in SACommonControls.dll succeeded. &nbsp;Thanks, but now what?
</div>


<div>
To answer my own last question I am still getting the fatal error. &nbsp;Thanks guys!
</div>


<div>
I am convinced we will have to use Oracle and incorporate the SQL table there as a View.
</div>


<div>
<div class="content wysiwyg-content">
 I have a SQL Server database that I am trying to link table to an Oracle database. &nbsp;Crystal does not like this and keeps giving me a fatal error. &nbsp; I would like to convert the SQL database to an Access database, but keep the data current. &nbsp;I tried to create an ODBC connection so the SQL tables would link in Access. &nbsp;I still cannot connect the Access source table to the Oracle table.<br />
&nbsp;<br />
1) I opened Access 2007<br />
2) I gave the filename as Access SQL<br />
3) I clicked the Create button<br />
4) I went to External Data tab and clicked More<br />
5)I selected ODBC database<br />
6) Picked Link to the data source by creating a linked table<br />
7)Selected Machine Datasource tab<br />
8) Chose Pickpro (my SQL source)<br />
9) Said Ok<br />
10) selected my table INVENTORY Map<br />
11) Double clicked on dbo.INVENTORY MAP<br />
12) Received all my rows and columns<br />
13) Is this live data? Is it being updated when I display it?<br />
14) Picked Save as 2002-2003 databse<br />
15) Put it in my network folder<br />
&nbsp;<br />
What did I do wrong? &nbsp;<br />

</div>
</div>


 I have a SQL Server database that I am trying to link table to an Oracle database.  Crystal does not like this and keeps giving me a fatal error.   I would like to convert the SQL database to an Access database, but keep the data current.  I tried to create an ODBC connection so the SQL tables would link in Access.  I still cannot connect the Access source table to the Oracle table.
 
1) I opened Access 2007
2) I gave the filename as Access SQL
3) I clicked the Create button
4) I went to External Data tab and clicked More
5)I selected ODBC database
6) Picked Link to the data source by creating a linked table
7)Selected Machine Datasource tab
8) Chose Pickpro (my SQL source)
9) Said Ok
10) selected my table INVENTORY Map
11) Double clicked on dbo.INVENTORY MAP
12) Received all my rows and columns
13) Is this live data? Is it being updated when I display it?
14) Picked Save as 2002-2003 databse
15) Put it in my network folder
 
What did I do wrong?  


Creating a link from a SQL database to an Access database using in Crystal

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.