RE: Help Oracle to Access
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <Paula_Stankus@xxxxxxxxxxxxxxx>, <jkstill@xxxxxxxxx>, <gkatteri@xxxxxxxxxxx>
- Date: Fri, 26 Aug 2005 09:52:20 -0400
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?