Access front-end to Oracle - How to?

Hi,

We have a Human Resources Database which also handles Organisational Structure among multiple Business Entities if required. It is currently written in Microsoft Access and has separate Application Database and Data Database. The data is fully normalised and consists of over 130 tables. The database works fine with the small number of concurrent users it currently has, but a client wants to move it to Oracle (back end) as that is their corporate-wide database. They want to make the "public" data in the HR DB generally available. Are there any information sources, white papers etc on how to do this?

The database design makes _extensive_ use of referential and semantic integrity to ensure high quality data (and, in fact, has been used to consistency check the operational application from which we import data).

We have large numbers of queries (both for look-up and processing).

We haven't implemented security in the past (because the application was HR internal).

Any pointers (and success stories from the front line) appreciated.

Thanx in Advanz

Regardz, Paolo F. Cantoni Tel: +61-2-9498 5945   Director Fax: +61-2-9418 4402
  -Semantica- Cell: +61-416 11 00 95 Suite 2, Charing House EMail: pcantoni_at_semantica.com.au 45 Kendall Street Web: http://www.semantica.com.au Pymble NSW 2073 AUSTRALIA

"Many problems turn out to be caused by invalid concepts. Conceptual Modelling provides techniques for solving them..."

-Semantica- can help your organisation understand itself better Received on Mon Aug 17 1998 - 23:10:13 CDT