gregseverywhere@h...,

After looking at your code,
here are two suggestions that
I have for you:

1) You need to include a DAO reference
library in your project, and remove
the ADO reference.

The reason why I suspect this is that
in the following line:

Dim wsMyODBC       As workspace

The letter w in workspace is not
capitalized.  If you are using
VB 5 or 6 then intelli-sense should
automatically capitalize the
word "workspace" if it was able to
identify what workspace was.

2) My suggestion would be to just
forget DAO, and use ADO to connect
to the Oracle Database.  By creating
a workspace of type dbUseODBC
you are essentially accessing the
database with pass through queries
bypassing the DAO engine anyway.

ADO will give your improved performance
and also, you will be able to take
advantage of different features of
your server that are inaccessible to
DAO.

Hope this helps you,

Cardyin

--------------------------------------
Cardyin Kim
C/S & Web Development Analyst
Information Services
San Antonio Community Hospital
ckim@s...     (xxx)xxx-xxxx     
--------------------------------------