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
Leif wrote: > 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-----
