i just need to create a data capture program...which does not require any
validation...just like forms..and the data i need to put in oracle
table...
santosh
-Original Message-
Sent: Tuesday, March 18, 2003 8:09 PM
To: Multiple recipients of list ORACLE-L
Santosh:
Would this project require any type of reporting which is highly formatted?
If not I would Stefan recommended and us VB6 (or VB.Net, if so use the MS
Oracel Data Provider). This will give you all the functionality you will
need. If basic reports are required you could always use the MS Excel
object to create them (Excel must be on the machine though).
From: Stefan Jahnke [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: AW: From Microsoft Access to Oracle
Date: Tue, 18 Mar 2003 05:23:43 -0800
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 http://www.bov.de/
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp
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] 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: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 -
To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 1:08 AM
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
_
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jay Wade
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Santosh Varma
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).
