SQL From Access for Crystal

[FinalPrime]

I’m new to combining Crystal/Access 2000 / SQL Server into one Access App.

So far, I’ve got a Crystal Report to run from an Access Form, whereby the Crystal is getting data from a SQL Server database. The SQL is in the Crystal.

But I need the SQL to be generated with-in the Access app. How is this done?

++++++++++++++
ODBC(ADO)
Access2000
Crystal 7.0
SQL Server 7
Connect string looks like
= DSN = Server ; UID = user ; PWD = me ; DSQ = MyData
+++++++++

any help appreciated,

final prime