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