Re: ACCESSing an PO7 DB

From: Gordon E. Hooker <gordonh_at_acslink.net.au>
Date: 1995/08/07
Message-ID: <4069is$gj1_at_dingo.cc.uq.oz.au>#1/1

roywagner_at_aol.com (Roy Wagner) wrote:

>Can someone simply and explicitely indicate the steps to take and the
>files to use ODBC or OLE 2.0 to access a PO7 database (such as ORACLE7's
>EMP table) with Microsoft's ACCESS 2.0.
 

>I'd like to use the Form and Report objects in ACCESS with data in an
>Oracle DB. I tried to read all the books and help files, but none seem to
>explicitely tell me the steps to take.
 

>Thank you! - Roy -

Roy,

Assuming PO7 is up and running, and you have set up ODBC and called the connection WG2000.

1. From the Access file menu choose new database, and give it a name.
2. From the file menu choose attach table, the attach dialog appears
3. select <SQL Database>
4. from the SQL Data Sources, choose WG2000 data source (you created this when you set up ODBC via the Oracle ODBC window)
5. the logon to Oracle dialog appears, enter your username and password
6. a list of tables will appear, select the table you want and press the attach button
7. continue with d until you have attached all the tables you require from the oracle database.

   These table are mapped to the MSAccess database and you can then refer to them like you would an Access table.

Hope this helps...

-----------------------------\ooOoo/-----------------------------------
Gordon Hooker MACS PCP                                     ,--_|\
25 Clarke Street, Ripley, Queensland, 4306, Australia     /      \ 
gordonh_at_acslink.net.au                                    \_.--._/
mobile: 018883835 phone: 61-7-2889716                           V
-----------------------------------------------------------------------

The opinions you read here are mine and not necessarily those of my employers. Although, I must say they are the truth, the whole truth, and nothing like the truth. As far as I'm concerned anyway... Received on Mon Aug 07 1995 - 00:00:00 CEST