Re: Looking for Access-like front-end tool

[Quoted] 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

[Quoted] 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 Received on Sat Apr 12 2003 - 01:21:48 CEST