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

View does not show up in query list

P: n/a
I created a view on an Access 2002 database through an ODBC query
tool. The view works fine either through ODBC or the Access IDE. The
problem I am having is that it does not show up in the Queries list on
the Access IDE. It's almost as if ODBC did not write a portion of the
data dictionary or something.. quite odd. Has anyone heard of this
problem before and know of a cause/solution? I would like to continue
to create the views without doing it through Access
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Access/Jet ODBC sees Views as though they were server Tables, not as
Queries, and, as any other Table, you have to link it.

Larry Linson
Microsoft Access MVP

"Waxabi X" <wa****@excite.com> wrote in message
news:e5**************************@posting.google.c om...
I created a view on an Access 2002 database through an ODBC query
tool. The view works fine either through ODBC or the Access IDE. The
problem I am having is that it does not show up in the Queries list on
the Access IDE. It's almost as if ODBC did not write a portion of the
data dictionary or something.. quite odd. Has anyone heard of this
problem before and know of a cause/solution? I would like to continue
to create the views without doing it through Access

Nov 12 '05 #2

P: n/a
No it is the opposite from what I think you are saying. I can see
Access "queries" as views in ODBC. But the opposite is not true. When
I create a view through ODBC in an access database, it will not show
up in the access IDE as a query although it is available through the
ODBC API as a view.

"Larry Linson" <la**********@ntpcug.org> wrote in message news:<D4*****************@nwrddc02.gnilink.net>...
Access/Jet ODBC sees Views as though they were server Tables, not as
Queries, and, as any other Table, you have to link it.

Larry Linson
Microsoft Access MVP

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.