I have never been found of Access user using odbc to hit the Oracle DB.
However, in many cases, the general user has some sort of mental block
when it comes to developing Oracle queries, but if is an access query
the user doesn't have any problems at all.
So, it kind of comes down to either taking the time to let educate every
possible user of Oracle, or letting them use Access. In a small
department, its easier to let them use Access, then just watch for and
help the users who are running the problem queries.
-----Original Message-----
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)
Sent: Wednesday, July 04, 2007 1:33 PM
To: oracle-l@(protected)
Subject: Oracle - MS Access - Does your company have a policy about
local vs. centralized data storage? (Perhaps a bit off topic?)
I'm trying to do a bit of research in my effort to put together a
project to
move from localized to centralized data storage for Access applications
and
other ODBC type things. I'm just wondering if any of you have any
related
policies at your companies? Do you allow localized Access data stores or
do
you centralize those data stores? I'm looking at allowing access
applications, but providing a means to easily request/create a data
store
for those applications in Oracle.
Thoughts?
RF
Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints
Father of Five, Husband of One,
Author of various geeky computer titles
from Osborne/McGraw Hill (Oracle Press)
Oracle Database 11g New Features Now Available for Pre-sales on
Amazon.com!
Sig V1.1
--
http://www.freelists.org/webpage/oracle-l
------------------------------------------------------------------------------
NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.
==============================================================================
--
http://www.freelists.org/webpage/oracle-l
