Re: From Microsoft Access to Oracle

2003-03-18 Thread Jay 



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 seenusing 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 thereand 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

RE: From Microsoft Access to Oracle

2003-03-18 Thread DENNIS WILLIAMS 
Santosh - Hopefully someone with more Access experience will reply, but from
what I understand you want to create the Oracle table first. Access can
create Oracle tables but it tends to use goofy data types. Then Access can
connect to that table.
 



Dennis Williams 
DBA, 40%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, March 18, 2003 12:09 AM
To: Multiple recipients of list ORACLE-L


Hello list,
 
   I want to create a new form in Access where user input will be
thereand 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: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: From Microsoft Access to Oracle

2003-03-18 Thread Santosh Varma 



Thanks 
to all who replied...
santosh

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Stefan JahnkeSent: 
  Tuesday, March 18, 2003 6:54 PMTo: Multiple recipients of list 
  ORACLE-LSubject: 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: [EMAIL PROTECTED] 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:[EMAIL PROTECTED].
  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:[EMAIL PROTECTED]Gesendet: Dienstag, 18. März 2003 
13:19An: Multiple recipients of list ORACLE-LBetreff: 
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 seenusing 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 thereand 
  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