We had same problems at 2 sites here. I dont allow access in Production, I can usually scare management enough to keep them out and I apply a LOGON trigger to stop any connection from access (and SQLPLUS etc for that matter, unless its a user that I allow). I do create a copy of PROD every day to TEST and they can do what they like on this database.
----- Original Message ----- Date: Monday, February 3, 2003 4:38 > Bill, > I have to live with people who want to usc Access too. I agree > wfth you it is a > pain in the a--. Our solution, with damagement's agreement, is to > only do what > is possible. I think that in your situation you'll have to do > likewise. The > problem being Access's local tables. What may help is if they > link the tables & > apply the appropriate limits on each. > > Dick Goulet > [EMAIL PROTECTED] wrote on 1/31/03 2:24 pm: > > > Hello, > > We are stuck with a group of users who insist on using MS access > 2K 9.0 on a > Win2K workstation as an adhoc query front end to an Oracle 8.1.7.4 > db on Sun. > > The problem is that their queries run OK when executed from > sqlplus directly > against Oracle, but are terrible when executed from access. This > is because > access has tables linked to the oracle tables, and access insists > on downloading > all the data, performing the joins and where clause filters on the > localworkstation. > > I don't know much about access, and don't want to; however, this > has been dumped > on us, so I am hoping that someone has experienced the same > problem and found a > solution. No, we can't dump access, and use something different; > for reasons > beyond our control (management), we have to make this work. > > I think the solution is to somehow force the query to be processed > on the Oracle > machine, and return only the result set. We have tried the access > "passthrough"option, but I believe that fails due to the newer > ansi syntax used by access. > (OUTER JOIN, INNER JOIN, etc.) The users insist on using access's > gui query > generator. > > Has anyone found a solution to this? Is there a good whitepaper > somewhere like, > "Using Access as a Front-End Query Tool to Oracle?" (I will search > google) > Thanks to all who have read this far, > More thanks to any responders, > Most thanks for any helpful advice > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > 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.net > -- > 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.net -- 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).