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