Re: Accessing data from an MS access db from an Oracle UNIX server

Andrea M. Segovia wrote:

> Hello,
>
> I am a newbie to Oracle databases....
>
> We have a visualization front-end tool connected to an Oracle back-end
> database on a Tru64 UNIX server. We also have clients with MS access
> databases who would like to share their data using this visualization
> tool but do not want to import their data into the Oracle server
> back-end.
>
> Is there any way we could use the Oracle backend to query the MS
> Access databases and merge this data with other data in the Oracle
> back-end for presentation by the visualization tool? Perhaps through
> ODBC or some other standard?
>
> The Oracle back-end is a a Tru64 UNIX server running Oracle 8i.
>
> Any input would be appreciated.
>
> Andrea Segovia
> A/Project Manager

Your management needs to stop playing games with those that have the MS Access databases and put all of the data into Oracle.

If you didn't have Oracle ... fine so you use MS Access. But once you have Oracle there is no excuse for business data sitting on PCs where there is no security, no guarantee of data integrity, and almost undoubtedly no nightly backup.

All that money for Oracle and they are letting a some whiners make the business decisions. Management ... needs to manage.

Move the d... data.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)