That code was for a File DSN. You would need to change the code to include
the full path to the file.

A system DSN (probably what you are using) should look like this.

cn.Open "DSN=mail;" & _
"Uid=user;" & _
"Pwd=password"

Of course, you need to edit "user" and "password"

-Greg


On 3/29/05 3:26 AM, in article
c5100b24cbd74b26ab4c260c9d59e74a@SQLMonster.com, "Toby Benjamin via
SQLMonster.com" <forum@SQLMonster.com> wrote:

> Hi I tried your code you gave me but got an error.
>
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
>
>
> any ideas?