Thanks for the response Kent.

So where in your UDF it says,
Quote:

FUNCTION ODBCSQL($NAME,$SERVER,$DB,optional $user)

I should:

1. replace the $NAME with The DSN name,
2. replace the $SERVER with the Name of Server \ Instance
3. replace the $DB with the Database name
Is this correct?
4. What would the optional $USER be for? The User DSN option you mentioned in the UDF??

Thanks again Kent. You're amazing!