Cannot use Access table in the Query Designer

[JeepGeek]

I have a complex Access query (with subqueries and parameters in the subqueries) that I am trying to recreate in Crystal 8.0.

I want cannot figure out how to pull an Access table into the SQL Designer. It seems to require an ODBC connection (which I would prefer not to use). I gave in and set up an ODBC connection to the access database (using "Microsoft Access Driver&quot and the Designer will not recognize it.

Help!!

 

[JeepGeek]

OK. I'm pretty embarrassed, I found out how to do this at home.

In case someone else hasn't had their coffee and does the same thing, don't try to look for the DSN of your ODBC drivers, use the "ODBC - Ms Access Database" when you are prompted by the "Log on Server" popup.


I'm going back under my rock now.