Re: MS Access & Oracle

> I have change an application that was developed over MS Access and the
 data
> was managed by MS Access.
> Now, the data has been exported to Oracle 7.3, and via ODBC the
 application
> in MS Access is reading and updating the data.
> The result is that the speed of the application has not increased, in
 some
> times the speed has decreased.
> I think that the problem is possible will be in the application MS Access
> that has not been develped thinking in a RDB engine like Oracle.
> If somebody have an answer for me, i will be congratulated
> My name is Pepe, from Spain
> My E-mail: pmiquel_at_drac.medusa.es

Pepe,
The database that was developed in MS Access that is now is Oracle can be streamlined now that you have the capabilities of Oracle at your finger tips. I suggest setting up the proper indexes and checking the SQL statements that MS Access generates. You can do this by clicking the SQL button in the Query Design screen. I also suggest that if you are using an earlier version of MS Access 2.0 or so that you use RULE based optimization.

Nevin Hahn
DBA
Univ. of Colo. Cancer Center Received on Tue Aug 19 1997 - 00:00:00 CEST