Access as Front End for Oracle

From: SePp <C_o_z_m_o_at_gmx.de>
Date: Wed, 27 Feb 2008 01:07:40 -0800 (PST)
Message-ID: <25171216-d3ac-45f7-a940-24f1a0ca096c@t66g2000hsf.googlegroups.com>


Hello all,

I'm looking for the pro's and con's for an MS Access Application which has an Oracle backend (Oracle Express).
Especially how it is about the auto commit ( I believe it is off ), the
multi user security and the speed of the application.

I know Oracle is very good with multiple users but how is it when I use MS Access as Frontend.
Is it still good, with the ODBC Connection and the linked tables?

What is about the ODBC connection. This slows the queries extremely down, doesn't it?

Very much thanks in advance!

Kind regards,
SePp Received on Wed Feb 27 2008 - 03:07:40 CST

Original text of this message