Re: Looking for Access-like front-end tool

From: Juergen Lueters <jlueters_at_intranet-engineering.de>
Date: Sat, 12 Apr 2003 01:44:09 +0200
Message-ID: <pan.2003.04.11.23.44.04.811867_at_intranet-engineering.de>

Am Sat, 12 Apr 2003 01:21:48 +0200 schrieb Juergen Lueters:

> On Sat, 12 Apr 2003 00:05:00 +0200, Rick Denoire wrote:
>

>> One employee in the company, not an IT specialist, uses MS Access to
>> connect to an Oracle DB. She can combine queries that include local
>> tables in her own Access database.
>> 
>> But: when she starts a query through ODBC, her computer gets unusuable
>> (too busy). Using the "pass though" mode won't help, since she does
>> not type any real code.
>> 
>> Is there any tool out there that would supply the function of
>> translating MS Access SQL into Oracle SQL, so that native Oracle SQL
>> can be executed in "pass through" mode while still keeping the
>> advantages of Access as a local DB? That would be a module to Access,
>> I guess.
>> 
>> A complete different front-end would be acceptable. It should be able
>> to address the Oracle DB in Oracle SQL, preferably keeping a king of
>> local DB at the same time. Or it could just substitute the Access GUI
>> and use the Access DB files, or something similar. Perhaps you got the
>> point. This lady just wants to click her queries without cumbersome
>> SQL knowledge, but using Oracle as backend too. Eh.. using Windows.
>> 
>> Any idea?
>> 
>> Bye
>> Rick Denoire

>
> There is an migration tool from oracle which migrates access database to
> oracle. I have used tha and it works.
>
> I am investigation excatly the problem for a customer. So far i got the
> following results.
>
> Openoffice.org/Staroffice does provide a interface to databases, including
> query administration, graphical table layout, and a form editor.
>
> You can use a jdbc or odbc driver.
>
> Linux
>
> The jdbc driver is working but allows read-only acces only. The
> Openoffice.org developers are blaiming oracle for wrong metadata. Anyway
> the openoffice version 1.1 since beta 2 (staroffice 6.1) does enable a
> workaround which
> will disable all user-permission checks and lead to read-write oracle
> driver.
> There is a unix odbc driver from www.easysoft.com which suffers from the same
> read-only problem. I called them today and they promised to check that.
>
>
> Windows
>
> I have not investigated the openoffice-windows-odbc-oracle configration
> (my customer wants a linux solution). That might work.
>
> I can check that.
>
>
>
> Juergen
I just checked that with w2k, oracle odbc and oracle db on linux server. Table access seems ok. emp and dept tables are writable. So for windows users there is a alternative.

Juergen Received on Sat Apr 12 2003 - 01:44:09 CEST