Doing Simple SQL Queries and Viewing them

[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
P.S. Is "SQL Pass-Through Query" what I really want? I think it is but I
don't really know the difference between that and a regular SQL Query.

 

[Duane Hookom]

If the tables are in the current MDB then you don't use a Pass-Through
query. You can either type in the SQL view or use the grid designer.

 

[Mark Watkins]

Where is the SQL view? I'm having trouble trying to find that. It's not
even found in the help. I am using Access 2002. If you could direct me to
te right spot or even give me a snapshot of an example, I'd appreciate it.

 

[Rick Brandt]

Where is the SQL view? I'm having trouble trying to find that. It's not
even found in the help. I am using Access 2002. If you could direct me to
te right spot or even give me a snapshot of an example, I'd appreciate

it.

Open a query in design view. Now in the toolbar you should have a button
with three choices for the query's view. Datasheet, Design, and SQL. You
should have those same choices available from the View option on the main
menu bar.