Re: Accessing Oracle DBA views via MS Access. Need Help.

Chuck Hamilton wrote:

> I'd like to attach the Oracle DBA_USERS view to an Access database
> where I store the user names. The problem is I don't know how to get
> Access to include views in the list of tables it allows you to attach.
>
> Is there a way to do this?
>
> TIA
> --
> Chuck Hamilton
> chuckh_at_dvol.com
>
> This message delivered by electronic sled dogs. WOOF!

Chuck,

Select the option 'View System Objects' (Options in the Tools menu in Access 7 - I think it was right click to Properties in Access 2) and you'll be able to see system tables and views via your odbc connection.

Doug

--
To God Be the Glory                               <><

*****************************************************
            Douglas B. Houston, Ed.D. (ABD)
                  Isaiah 40:28-31
        860 Palo Verde  Barstow, CA 92311
    (760) 252-7427           (760) 252-4465  Fax
 dhouston1_at_mindspring.com  dhouston_at_barstow.cc.ca.us
*****************************************************