Accessing a linked table

[shaunk]

I have an Access database with a table that is linked to an SQL Server ODBC datasource. If you attempt to open the table in access, it prompts you for authorisation from SQL.
However, if I add the linked table as a datasource to Crystal, there is no authorisation/prompting and when I run the report a message is thrown "No physical database".
How do I pass thru the security layer to Crystal.

 

[Katy44]

You obviously have some sort of link to the SQL Server database to link the table in Access, so can't you add a completely new datasource to the report which is to the SQL Server db, and then use that in your report as well as the Access connection?

 

[synapsevampire]

If you link to a SQL Server table within Access, at the time of the link you can select Save Password, which will allow you to ALWAYS use the table in Access or Crystal without passing credentials.

-k