Views and Tables

[Leif]

I'm trying to set up access to an Oracle database from Access 2003. I've set
up my ODBC connections and I can see the tables. I've asked for access to
the views as well as tables. Should the view names show up as table names
when I create an Access linked table using the ODBC database? I don't see
them. I don't know if that is because Access only shows tables and not
views, or if I don't yet have access to the views.

Thanks,
Leif

 

[MGFoster]

I'm trying to set up access to an Oracle database from Access 2003. I've set
up my ODBC connections and I can see the tables. I've asked for access to
the views as well as tables. Should the view names show up as table names
when I create an Access linked table using the ODBC database? I don't see
them. I don't know if that is because Access only shows tables and not
views, or if I don't yet have access to the views.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

All Views in ODBC linked DBs should show up as tables. You'll have to
check w/ the Oracle DB admin to get you set up w/ permissions on the
views.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSNxVIoechKqOuFEgEQIrmgCgkRV7SR8F4lLWU+ZlroI/T+VsuAwAoOAe
kIGNye7RYnlq5jbzSI/vCC4j
=GzNj
-----END PGP SIGNATURE-----