Using access as a front end to an oracle database

  • Thread starter Thread starter STEVE
  • Start date Start date
S

STEVE

Hello

We are trying to develop a simple interface for an oracle 8i database, and
are considering access.

The interface will be used to set some data warehouse parameters and
settings. The warehouse is loaded from another oracle data base but we need
to add some simple forms, so that administrators can set it up.

We also want to enable users to simply upload excel data into the oracle
database.

Firstly is this possible? We were thinking of using linked tables...

Are there any performance issues or problems we should be aware of?

Any help would be greatly appreciated.

Cheers

Steve
 
It is very common.
I use the driver MS ODBC for Oracle. No trouble in 5 years.
I use linked tables in A97 too.
Basic idea is to limit the data on a form to a few records (under 200 or
even just 1.)
Do NOT bind to huge tables.
For complex stuff you can use Pass Through Queries (which are read only but
execute on the server using Oracle syntax.)
 
Back
Top