RE: Help Oracle to Access

Paul,
 
    Well there are a couple of ways to import Oracle data into Access.
Personally I prefer the link method as it leaves the data in the Oracle
database.  Fully exporting the data to Access is a BAD idea.  Yes I know
the person asking is probably a lot more comfortable with Access than
Oracle, but I don't want to remember the number of times that an Access
dbf file here has been deleted, overwritten or otherwise fouled up by an
application user who was trying to do something else, like clean up disk
space.  Although great for a single user, in a multi user environment
it's a nightmare waiting to happen & it will, more than once.  You also
have the fun of trying to explain to the users and damanagement that
whatever was done since the lost backup is lost forever.  It took a very
nasty problem like that causing us to scrap a lot of modules that
brought that to an end.  So just link the tables.  Access will then
behave itself instead of acting like a virus ready to strike.

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Paula_Stankus@xxxxxxxxxxxxxxx
Sent: Thursday, August 25, 2005 9:23 PM
To: jkstill@xxxxxxxxx; gkatteri@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: re: Help Oracle to Access


I  know it seems backward but I got a request to move Oracle database to
access.  What is the easiest way to do this?

Other related posts: