By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,474 Members | 3,214 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,474 IT Pros & Developers. It's quick & easy.

Help with Configuring ODBC Data Sources to run SQL Pease!

P: n/a
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 )
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Nov 12 '05 #2

P: n/a
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.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.