Basically I've written a Crystal Report that queries 2 different
databases: SQL Server and Access 97. Within the same Access 97 database
on a switchboard I have placed the Crystal Report control 4.6 and a
command button that sets the action =1 on the control when the button
is clicked. This worked fine when only the SQL Server is queried
however when the Access database is queried in conjunction with SQL I
get a run-time error message error 20527 saying there's a SQL server
error.

I'm very new at VB programming so your help would be much appreciated.
Thanks in advance...

Sent via Deja.com http://www.*-*-*.com/
Before you buy.