Jim,

I've not been following this thread, so please forgive me if this has already been discussed and shot down, but why not use a connection string instead of a connection. Then you can just fill in the username and password before you ever try to make the connection via SQLSTRINGCONNECT()

HTH,
Chad

>ALL,
>
> Ok, I've been sitting at work looking at this ODBC issue for the past 4 hours. I need to know if there is a way to have a connection in a project and set the properties, such as userid and password, BEFORE connecting.
>
>Thanks
>
>Jim