Help with Configuring ODBC Data Sources to run SQL Pease!

[Wayfarer]

I am new to Access - classes were all in Oracle. Now I am trying to
actually real world set up and run an Access database for a club I belong
to. I have a couple of books on Access but unable to find the help I need.

I am running Windows 98 SE and Access 2000.

I want to run SQL queries. So in Access I open a New Query and select SQL
Specifc, then SQL Pass Through.

This is where I am having diificulty. It requests I select my Data Source.
When I try to add the DSN Name, my system freezes.

What am I doing wrong and how can I (step by step please) do this correctly?

Much appreciated.

--
Marta
(if you email me directly you need to remove the X )

[DCM Fan]

Pass-through queries are used to connect to other database backends in their
"native SQL."

Since you're using Access to store data, there's no such thing as
"pass-throug."

When you're in that grid, and you're tempted to choose
Query>SQL-specific>Pass-though, go to View>SQL instead. Then you can type
native Access-SQL in there.

[Wayfarer]

Thanks, will try it.

--
Marta
(if you email me directly you need to remove the X )
"DCM Fan" <dc****@aol.comSPNOAM> wrote in message
news:20***************************@mb-m23.aol.com...

Pass-through queries are used to connect to other database backends in their "native SQL."

Since you're using Access to store data, there's no such thing as
"pass-throug."

When you're in that grid, and you're tempted to choose
Query>SQL-specific>Pass-though, go to View>SQL instead. Then you can type
native Access-SQL in there.