Rich,
As I stated in a previous post, we've got that GOD forsaken tool running
around here as well. Now Access is capable of doing it's own DDL in Oracle, but
I would not allow it since you get all of these object names with spaces & case
sensitivity in them. Basically to access them from outside Access you have to
enclose all of the table and column names in double quotes. So, what do I do?
Well first I don't allow the end users to process their own DDL, a developer has
to do that and for the real duhvelepors, I have them send the ddl over here & I
run it, after suitable editing. Then they attach to the tables as 'pass thru
queries'. It helps although it's not the best solution. Also, if they crash
one of their access DB's (and I don't care if it's production or not) I have a
good laugh, period.
Simply put, Access is NOT an IS supported tool. Your on your own.
Dick Goulet
____________________Reply Separator____________________
Author: "Jesse; Rich" <[EMAIL PROTECTED]>
Date: 5/11/2001 1:11 PM
So, there I am. An Oracle DBA with a host of MS Access databases that
end-users have created to do reporting via linked tables. Fine.
All of a sudden, one of these MS Access databases gets corrupted. Guess
what? It was also used to enter and hold production data! Eek!
I would like to create an Oracle DB (8i) and allow the end user to create
and manipulate Oracle tables that they can then link to their MS Access
queries/forms/reports. It doesn't look that that can be done using MS
Access' weak toolset.
We were guessing that we may be able to create a custom Perl CGI to have the
end-user do their own DDL on a webpage, but this seems like we might be
reinventing the wheel.
Has anyone given end-users (read: know nothing about Oracle) carte blanche
access to do their own DDL? What tools did you use?
TIA,
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
