Link Access Datebase to SQL database in Crystal 8

[JDMiller]

I am liking an Access database to a SQL database by part nbr. Both fields are indexes. Crystal only allows and equal join. Why? Can I get around this?

 

[Turkbear]

Hi,
It is not Crystal, it is the ODBC drivers and/or differing database structures that do not allow it.
Bring the SqlServer ( Not just SQL, that is a language, not a database) data into Access.

( Or the Access data into SqlServer )





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Sure, instead of using Crystal to do this, take the long haul approach, plus improve performance by LINKing the tables into an Access database, either the existing one or creat a new one and link both the current Access DB and the SQL Server db into it.

To do so select New in the tables sectiona nd select Link. Link to the data source (make sure you select save password) and you'll have all of the tables in one Access database.

Now create a query in Access as your Crystal datasource.

This has multiple advantages, not the least of which is that it's available to any tool which can read in an Access database.

Also make sure that you turn on the database show views in Crystal to use an Access Query.

-k

 

[synapsevampire]

I should have qualified and staed don't "bring the data into Access" (nor vice-cersa) as Turk suggests, use the LINK, not Import.

That way it's always dynamic.

-k

 

[Turkbear]

Hi,
Correct - Link for dynamic data that needs to be 'live'.
If periodically extracted data is sufficient, however, actually importing the data on a scheduled basis, may make the report faster..









To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Ahhh, good point, Turk.

Imported data shoudl be much faster, and you can index it as well.

-k

 

[JDMiller]

Thanks for all your responses. I started in Access. Sounds like I should just keep the process in Access.