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