View does not show up in query list

[Waxabi X]

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

[Larry Linson]

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

[Waxabi X]

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