Oracle-L: Re: From Microsoft Access to Oracle

From: Jay <fish_dba_at_hotmail.com>
Date: Tue, 18 Mar 2003 04:19:08 -0800
Message-ID: <F001.0056C4FC.20030318041908@fatcity.com>

The easiest way is to ODBC link the tables and develop like it is an MS Access project. This is not the best way due to security and a host of other issues. I have seen using ADO & oo4o through VBA to make the connection. This seems to work ok, but does require alittle more coding then the average MS Access database project.

OTN has some great sections of using ADO and oo4o.

Original Message ----- From: Santosh Varma To: Multiple recipients of list ORACLE-L Sent: Tuesday, March 18, 2003 1:08 AM Subject: From Microsoft Access to Oracle

Hello list,

I want to create a new form in Access where user input will be there....and the data entered i have to store it in Oracle database. Can anyone of you guide me in doing this..How ???

Thanks and Regards,
Santosh

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jay
INET: fish_dba_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Mar 18 2003 - 06:19:08 CST