Re: Access front-end to Oracle - How to?

Actually, the solution is not that complex: 1. Make sure you can access the Oracle db from your pc. The way I did

   that was by use of ODBC
2. In MS access you can access Oracle database tables by ODBC. All you

   do is, with an access database already open, click on 'New Table',    and choose 'Link Table'. From there, assuming everything is working    right, you should get access to your Oracle database tables. 3. All you have to do is to migrate the MS Access tables over to Oracle,

   that may not be easy. At the end, from a MS Access perspective, a    certain table in Access must have the same name in order to have your    MS Access app work against the oracle db.

Have fun.

Roy

Paolo F. Cantoni wrote:
>
> 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 Tue Aug 18 1998 - 00:33:06 CDT