I can send you a sample of what works for me when I get to work tomorrow...

Tim



"Jim Heavey" wrote in message
...
Thanks for your response. I am perfectly able to connect to the table
when I
use the macro recorder, so I am finding it difficult to thing it has
anything
to do with TNSNames. But I entered the command you suggested and I got
the
following:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL
=
TCP)
(HOST = XXX.XX.XX.XX)(PORT = YYYY))) (CONNECT_DATA = (SERVICE_NAME =
EBWP)))
OK (430 msec)

This seems to suggest that it worked just fine... doesn't?