Looking for Access-like front-end tool

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Sat, 12 Apr 2003 00:05:00 +0200
Message-ID: <9t9e9v0o6adaarid75he2715bakprl7oie_at_4ax.com>



[Quoted] 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 Received on Sat Apr 12 2003 - 00:05:00 CEST

Original text of this message