RE: Oracle - MS Access - Does your company have a policy about local vs. centralized data storage? (Perhaps a bit off topic?)

From: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Thu, 5 Jul 2007 07:43:22 -0500
Message-ID: <D40740337A3B524FA81DB598D2D7EBB3097A8644@x6009a.umb.corp.umb.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Robert Freeman Sent: Wednesday, July 04, 2007 1:33 PM
To: oracle-l_at_freelists.org
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 Received on Thu Jul 05 2007 - 07:43:22 CDT