Message-Id: <24703.322275@fatcity.com> From: "Santosh Varma" Date: Wed, 19 Mar 2003 09:36:29 +0530 Subject: RE: From Microsoft Access to Oracle This is a multi-part message in MIME format. ------=_NextPart_000_0262_01C2EDFB.095AE040 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Thanks to all who replied... santosh -----Original Message----- From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Stefan Jahnke Sent: Tuesday, March 18, 2003 6:54 PM To: Multiple recipients of list ORACLE-L Subject: AW: From Microsoft Access to Oracle Hi We extensively used OO4O with Access 2000. It works fine, gives you all the Oracle specific stuff, but ... it's more work, since you have to code more things. I personally think it's worth it, eventhough I wouldn't go with Access in the first place. If it has to be VB, why not use VB 6.0 and Access just to display reports. There are lots of things (e.g. using ocx controls like the MS tree control in Access) that make you want to commit suicide. Nevertheless, the data access itself through OO4O works and we didn't have any problems with it. Regards, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: stefan.jahnke@nospam.bov.de Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:andrea.palluck@bov.de. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -----Ursprüngliche Nachricht----- Von: Jay [mailto:fish_dba@hotmail.com] Gesendet: Dienstag, 18. März 2003 13:19 An: Multiple recipients of list ORACLE-L Betreff: Re: From Microsoft Access to Oracle 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 ------=_NextPart_000_0262_01C2EDFB.095AE040 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Thanks=20 to all who replied...

santosh

-----Original Message-----
From: root@fatcity.com=20 [mailto:root@fatcity.com]On Behalf Of Stefan = Jahnke
Sent:=20 Tuesday, March 18, 2003 6:54 PM
To: Multiple recipients of = list=20 ORACLE-L
Subject: AW: From Microsoft Access to=20 Oracle

Hi

We=20 extensively used OO4O with Access 2000. It works fine, gives you all = the=20 Oracle specific stuff, but ... it's more work, since you have to code = more=20 things.

I=20 personally think it's worth it, eventhough I wouldn't go with Access = in the=20 first place. If it has to be VB, why not use VB 6.0 and Access just to = display=20 reports. There are lots of things (e.g. using ocx controls like the MS = tree=20 control in Access) that make you want to commit = suicide.

Nevertheless, the data access itself through OO4O works = and we=20 didn't have any problems with it.

Regards,

Stefan

Stefan Jahnke =
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: stefan.jahnke@nospam.bov.de
Please remove nospam to contact me = via=20 email.

visit our website: http://www.bov.de =
subscribe to our newsletter: http://www.bov.de/presse= /newsletter.asp=20

Sicherheitsluecken mit=20 IT-Security-Konzepten von BOV effizient schliessen! Weitere = Informationen=20 unter +49 201/45 13-240 oder E-Mail an mailto:andrea.palluck@bov.de.

Wie Sie wissen, koennen = ueber das=20 Internet versandte E-Mails leicht unter fremden Namen erstellt = oder=20 manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis = dafuer,=20 dass wir zu Ihrem und unserem Schutz die rechtliche = Verbindlichkeit der=20 vorstehenden Erklaerungen und Aeusserungen ausschliessen.

As you are probably aware, = e-mails sent=20 via the Internet can easily be copied or manipulated by third parties. = For=20 this reason we would ask for your understanding that, for your own = protection=20 and ours, we must decline all legal responsibility for the validity of = the=20 statements and comments given above.

-----Urspr=FCngliche Nachricht-----
Von: Jay=20 [mailto:fish_dba@hotmail.com]
Gesendet: Dienstag, 18. = M=E4rz 2003=20 13:19
An: Multiple recipients of list = ORACLE-L
Betreff:=20 Re: From Microsoft Access to Oracle

The easiest way is to ODBC link the = tables and=20 develop like it is an MS Access project.

This is not the best way due to = security and a=20 host of other issues.

I have seen using ADO & = oo4o through=20 VBA to make the connection.

This seems to work ok, but does = require alittle=20 more coding then the average MS Access database = project.

OTN has some great sections of = using ADO and=20 oo4o.

----- Original Message ----- =
From:=20 Santosh=20 Varma
To: Multiple recipients of list=20 ORACLE-L

Sent: Tuesday, March 18, = 2003 1:08=20 AM

Subject: From Microsoft = Access to=20 Oracle

Hello=20 list,

I=20 want to create a new form in Access where user input will be = there....and=20 the data entered i have to store it in Oracle=20 database.

Can anyone of=20 you guide me in doing this..How ???

Thanks and Regards,

Santosh =