Re: Using Access 97 and Oracle 7.3

"R.J.W. Kremers" <kremersr_at_edte.utwente.nl> wrote:

>Hello all,
>
>I am new in the field of Oracle 7.3 and have only limited experience
>with Access.
>Could anyone of you tell me what exactly I have to do in order to
>connect Access with Oracle 7.3?
>
>Probably:
>- File| New database
>- File| Get external data| Link tables --> ODBC Databases
>
>But what do I have to fill in next?
>Or am I completely wrong?
>
>Many thanks
>Rob Kremers
>University of Twente
>Netherlands
>kremersr_at_edte.utwente.nl
>

Close, but not quite....

Open an existing Access database, go to Tables tab and select New; You have 2 options Link and Import:

Link just links ( hence the name, duh ) Access to an Oracle table but does not transfer data to access, butr allows you to manipulate the data in Oracle.

Import connects to Oracle and 'downloads' the table structure and Data to make an Access table within the selected database.

Both use ODBC ( usually ) to make the connection and which to use depends on what you want to do with the Oracle data - For Updates,deletes,inserts use the link, for selects ( for report writing, analysis in a spreadsheet etc. ) and other read-only operations on a relatively static table, use the import ( it will access the data faster ),

I have been using this combination for a while, and find it helpful in

some instances. By and large, its been 'gotcha' free.

Note: It does take a decent PC with 32MB or more of Ram and lots of Disk space to work really well.

Hope It Helps.
Reply to john.greco_at_dot.state.mn.us Received on Tue Dec 16 1997 - 00:00:00 CST