Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: From Microsoft Access to Oracle

RE: From Microsoft Access to Oracle

From: Santosh Varma <vsantosh_at_psi.soft.net>
Date: Wed, 19 Mar 2003 09:36:29 +0530
Message-Id: <24703.322275@fatcity.com> 





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_at_fatcity.com [mailto:root_at_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_at_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_at_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_at_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.






      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


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =


charset=3Diso-8859-1">



<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><SPAN class=3D662220604-19032003><FONT face=3DArial color=3D#0000ff =


size=3D2>Thanks=20


to all who replied...</FONT></SPAN></DIV>
<DIV><SPAN class=3D662220604-19032003><FONT face=3DArial color=3D#0000ff =



size=3D2>santosh</FONT></SPAN></DIV>


<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">


  <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =

face=3DTahoma=20


  size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20
  [mailto:root_at_fatcity.com]<B>On Behalf Of </B>Stefan =
Jahnke<BR><B>Sent:</B>=20


  Tuesday, March 18, 2003 6:54 PM<BR><B>To:</B> Multiple recipients of =
list=20


  ORACLE-L<BR><B>Subject:</B> AW: From Microsoft Access to=20
  Oracle<BR><BR></FONT></DIV>


  <DIV><SPAN class=3D839482013-18032003><FONT face=3DArial =

color=3D#0000ff=20


  size=3D2>Hi</FONT></SPAN></DIV>


  <DIV><SPAN class=3D839482013-18032003><FONT face=3DArial =

color=3D#0000ff=20


  size=3D2></FONT></SPAN>&nbsp;</DIV>


  <DIV><SPAN class=3D839482013-18032003><FONT face=3DArial =

color=3D#0000ff size=3D2>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.</FONT></SPAN></DIV>


  <DIV><SPAN class=3D839482013-18032003><FONT face=3DArial =

color=3D#0000ff size=3D2>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.</FONT></SPAN></DIV>


  <DIV><SPAN class=3D839482013-18032003><FONT face=3DArial =

color=3D#0000ff=20


  size=3D2>Nevertheless,&nbsp;the data access itself through OO4O works =
and we=20


  didn't have any problems with it.</FONT></SPAN></DIV>


  <DIV><SPAN class=3D839482013-18032003><FONT face=3DArial =

color=3D#0000ff=20


  size=3D2></FONT></SPAN>&nbsp;</DIV>


  <DIV><SPAN class=3D839482013-18032003><FONT face=3DArial =

color=3D#0000ff=20


  size=3D2>Regards,</FONT></SPAN></DIV>


  <DIV><SPAN class=3D839482013-18032003><FONT face=3DArial =

color=3D#0000ff=20


  size=3D2>Stefan</FONT></SPAN></DIV>


  <DIV>&nbsp;</DIV>

  <P><FONT face=3D"Century Gothic" size=3D2>Stefan Jahnke</FONT> =

<BR><FONT=20


  face=3D"Century Gothic" size=3D2>Consultant</FONT> <BR><FONT =
face=3D"Century Gothic"=20


  size=3D2>BOV Aktiengesellschaft</FONT> <BR><FONT face=3D"Century =
Gothic"=20


  size=3D2>Voice: +49 201 - 4513-298</FONT> <BR><FONT face=3D"Century =
Gothic"=20


  size=3D2>Fax: +49 201 - 4513-149</FONT> <BR><FONT face=3D"Century =
Gothic"=20


  size=3D2>mailto: stefan.jahnke_at_nospam.bov.de</FONT> <BR><FONT=20
  face=3D"Century Gothic" size=3D2>Please remove nospam to contact me =
via=20


  email.</FONT> </P>


  <P><B><FONT face=3D"Century Gothic" size=3D2>visit our website: <A =

target=3D_blank=20


  href=3D"http://www.bov.de/">http://www.bov.de</A></FONT></B> =
<BR><B><FONT=20


  face=3D"Century Gothic" size=3D2>subscribe to our newsletter: <A =
target=3D_blank=20


  =


href=3D"http://www.bov.de/presse/newsletter.asp">http://www.bov.de/presse=
/newsletter.asp</A></FONT></B>=20


  </P>

  <P><FONT face=3D"Century Gothic" size=3D1>Sicherheitsluecken mit=20

  IT-Security-Konzepten von BOV effizient schliessen! Weitere =
Informationen=20


  unter +49 201/45 13-240 oder E-Mail an <A=20
  =


href=3D"mailto:andrea.palluck_at_bov.de">mailto:andrea.palluck_at_bov.de</A>.</=
FONT></P>


  <P><FONT face=3D"Century Gothic" size=3D1>Wie Sie wissen, koennen =

ueber das=20


  Internet versandte E-Mails leicht unter fremden Namen&nbsp; erstellt =
oder=20


  manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis =
dafuer,=20


  dass&nbsp; wir zu Ihrem und unserem Schutz die rechtliche =
Verbindlichkeit der=20


  vorstehenden Erklaerungen und Aeusserungen ausschliessen.</FONT></P>


  <P><FONT face=3D"Century Gothic" size=3D1>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.</FONT></P>


  <BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">

    <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20


    size=3D2>-----Urspr=FCngliche Nachricht-----<BR><B>Von:</B> Jay=20
    [mailto:fish_dba_at_hotmail.com]<BR><B>Gesendet:</B> Dienstag, 18. =
M=E4rz 2003=20


    13:19<BR><B>An:</B> Multiple recipients of list =
ORACLE-L<BR><B>Betreff:</B>=20


    Re: From Microsoft Access to Oracle<BR><BR></FONT></DIV>
    <DIV><FONT face=3DArial size=3D2>The easiest way is to ODBC link the =
tables and=20


    develop like it is an MS Access project.</FONT></DIV>
    <DIV><FONT face=3DArial size=3D2>This is not the best way due to =
security and a=20


    host of other issues.</FONT></DIV>


    <DIV><FONT face=3DArial size=3D2>I have seen&nbsp;using ADO &amp; =
oo4o through=20


    VBA to make the connection.</FONT></DIV>
    <DIV><FONT face=3DArial size=3D2>This seems to work ok, but does =
require alittle=20


    more coding then the average MS Access database =
project.</FONT></DIV>


    <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
    <DIV><FONT face=3DArial size=3D2>OTN has some great sections of =
using ADO and=20


    oo4o.</FONT></DIV>


    <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
    <BLOCKQUOTE dir=3Dltr=20


    style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">


      <DIV style=3D"FONT: 10pt arial">----- Original Message ----- =
</DIV>

      <DIV=20
      style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
      <A title=3Dvsantosh_at_psi.soft.net =
href=3D"mailto:vsantosh_at_psi.soft.net">Santosh=20
      Varma</A> </DIV>
      <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
title=3DORACLE-L_at_fatcity.com=20
      href=3D"mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list=20
      ORACLE-L</A> </DIV>
      <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Tuesday, March 18, =
2003 1:08=20
      AM</DIV>
      <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> From Microsoft =
Access to=20
      Oracle</DIV>
      <DIV><BR></DIV>
      <DIV><SPAN class=3D649050606-18032003><FONT face=3DArial =
size=3D2>Hello=20
      list,</FONT></SPAN></DIV>
      <DIV><SPAN class=3D649050606-18032003><FONT face=3DArial=20
      size=3D2></FONT></SPAN>&nbsp;</DIV>
      <DIV><SPAN class=3D649050606-18032003><FONT face=3DArial =
size=3D2>&nbsp;&nbsp; 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.</FONT></SPAN></DIV>
      <DIV><SPAN class=3D649050606-18032003><FONT face=3DArial =
size=3D2>Can anyone of=20
      you guide me in doing this..How ???</FONT></SPAN></DIV>
      <DIV><SPAN class=3D649050606-18032003><FONT face=3DArial=20
      size=3D2></FONT></SPAN>&nbsp;</DIV>
      <DIV>
      <DIV>
      <DIV><FONT face=3DArial size=3D2>Thanks and Regards,</FONT></DIV>
      <DIV><FONT face=3DArial><FONT size=3D2>Santosh&nbsp;<SPAN=20
      class=3D649050606-18032003>&nbsp;&nbsp;&nbsp; =


</SPAN></FONT></FONT></DIV>
Received on Tue Mar 18 2003 - 22:06:29 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US