Connecting to a DB in VBA
 

I'm trying to connect to an ODBC-compatible database thru VBA, but I can't
seem to get it to work. I've looked at the help files, and some of the
things it tells me to do, aren't recognized when I try to run them.
Example:
Dim wrkODBC as WorkSpace
It doesn't recognize the "user-defined type". I'm wondering if I'm missing
some AddIn or something. I've installed everything that came with the disk,
as well as made sure that they were selected in the options portion of
Excel, but nothing is dealing with ODBC connections.
Can somebody please tell me what I'm doing wrong and how to fix this?
Thanks!!!

XP Home
Excel 2002
ASA 8 DB (thru ODBC connection)

Connecting to a DB in VBA
 

See reply to my Q on "ACT!" 14/1/04, may help.
AB

"Tom S" wrote in message
...
I'm trying to connect to an ODBC-compatible database thru VBA, but I can't
seem to get it to work. I've looked at the help files, and some of the
things it tells me to do, aren't recognized when I try to run them.
Example:
Dim wrkODBC as WorkSpace
It doesn't recognize the "user-defined type". I'm wondering if I'm
missing
some AddIn or something. I've installed everything that came with the
disk,
as well as made sure that they were selected in the options portion of
Excel, but nothing is dealing with ODBC connections.
Can somebody please tell me what I'm doing wrong and how to fix this?
Thanks!!!

XP Home
Excel 2002
ASA 8 DB (thru ODBC connection)