Doing Simple SQL Queries Viewing Results

[Mark Watkins]

I think I've gotten to the point where I should be able to see the results
of an SQL Query if I just type in the "SQL Pass-Through Query" window.
Everytime I try to run the query, I get a prompt to "Select Data Source". I
tried using the "Microsoft Access Driver (*.mdb)", but no dice. I've tried
several things and I keep getting:

"You cannot use ODBC to import from, export to, or link an external
Microsoft Jet or ISAM database table to your database."

All I really want to do is see the results of my SQL queries such as this
one:

SELECT * FROM schedule

How simpler can you get? I just can't figure this thing out.My DB is in
Access 2000 format.

I recall from an Oracle class I took that we could do things such as view
SQL queries with ease through using sqlplus. Is there some kind of
equivalent command prompt in Access? Now I'm just rambling and wishing upon
a star. If anyone can help, I'd appreciate it.

Mark

 

[MacDermott]

You don't need a pass-through query to do what you want.

Open a new query, dismiss the Add Table Dialog, and click the SQL button in
the upper left-hand corner.
Type your SQL into the SQL window which opens, then click the Run button.

HTH
- Turtle