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

"SePp" <C_o_z_m_o (AT) gmx (DOT) de> wrote

What is slow is poorly written applications. If you don't use bind
variables and you write crappy code then it will be slow. If you use bind
variables and effecient code the it won't.
Jim

"SePp" <C_o_z_m_o (AT) gmx (DOT) de> wrote

What is slow is poorly written applications. If you don't use bind
variables and you write crappy code then it will be slow. If you use bind
variables and effecient code the it won't.
Jim

"SePp" <C_o_z_m_o (AT) gmx (DOT) de> wrote

What is slow is poorly written applications. If you don't use bind
variables and you write crappy code then it will be slow. If you use bind
variables and effecient code the it won't.
Jim

"SePp" <C_o_z_m_o (AT) gmx (DOT) de> wrote

What is slow is poorly written applications. If you don't use bind
variables and you write crappy code then it will be slow. If you use bind
variables and effecient code the it won't.
Jim

SePp wrote:
MS Access is not a front-end and it is not a relational database.

If you want to front-end an application think JDeveloper or .NET
or PHP or any number of other possible tools.

If want reports think Discoverer, Siebel Analytics, Crystal,
Hyperion, etc.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

SePp wrote:
MS Access is not a front-end and it is not a relational database.

If you want to front-end an application think JDeveloper or .NET
or PHP or any number of other possible tools.

If want reports think Discoverer, Siebel Analytics, Crystal,
Hyperion, etc.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

SePp wrote:
MS Access is not a front-end and it is not a relational database.

If you want to front-end an application think JDeveloper or .NET
or PHP or any number of other possible tools.

If want reports think Discoverer, Siebel Analytics, Crystal,
Hyperion, etc.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

SePp wrote:
MS Access is not a front-end and it is not a relational database.

If you want to front-end an application think JDeveloper or .NET
or PHP or any number of other possible tools.

If want reports think Discoverer, Siebel Analytics, Crystal,
Hyperion, etc.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org