Unfortunately, the ACCESS virus has been let loose in my company. The main production Oracle database consumes about 150GB. The total sum of ACCESS files in now at 200+GB & growing at a faster rate than the Oracle files. The users spend a LOT of time trying to reconcile differences between various Access "snapshots" (taken at different times) and Production Oracle DB. Giving ACCESS to users can be as dangerous as giving them SQL*Plus so they can change data bypassing the various data sanitizing routines resulting in "dirty data".
Be afraid. Be VERY afraid! HTH & YMMV! =================================================================== Rick_Cale@teamhea lth.com To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: OT: Guidelines/Standards for supporting non-oracle databases 12/10/2002 01:15 PM Please respond to ORACLE-L Hi, We are virtually an Oracle shop with 2-3 sql server databases due to 3rd-party software restrictions. We have been asked about supporting other "small" databases such as Access,etc within our company. My question is if you were asked to support "smaller" databases what restrictions/guidelines/standards are worth considering? Be kind-constructive answers only :-) Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).