How select statement write on Access view with MSSQL data source?


I created views in MSSQL 2005 express to view tables of a DB. I use ODBC to connect the views in MS ACCESS. I can see the views of those tables set in MSSQL.

However, how should I write the select statement in ACCESS to sort the views in MSSQL?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Leigh PurvisDatabase DeveloperCommented:
A simple select statement will be effectively ANSI standard in both T-SQL and Jet SQL.
(i.e. it should look effectively the same).
SELECT * FROM LinkedViewName
ORDER BY FieldName
Is that what you meant by "sort the views"?
Or are you wanting an ordered list of the Views you have linked to?
Perhaps if you describe the greater objective we can offer a more precise suggestion?
techquesAuthor Commented:

I want to make a select statement in ACCESS

select * from table where name = 'abc' order by id desc

As it is an ACCESS view link to DB view, I do not know how can I do it in ACCESS
Leigh PurvisDatabase DeveloperCommented:
Oh - you mean how to just create a query in Access?
You don't mention a version - in 2007 you'd need to view the Create tab on the ribbon (as I recall :-s) but in previous versions you can choose:
Insert Menu > Query > Design View > View > SQL
Then write your SQL and save the query as whatever name you choose.
That query is then effectively a View (though Access/Jet queries are a sort of limited hybrid between Views and SPs - in that they can be ordered, accept parameters etc).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
techquesAuthor Commented:
I use Access 2002
Leigh PurvisDatabase DeveloperCommented:
OK - then as directed above then?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.