Why not use NY authentication rather than a SQL user ID? That way they don't get prompted for a login b/c SQL detects their NT user ID.

You...

Thanks Sue. I actually have a database name, password, and user ID in my code, but I deleted it from the post. Even when I include those it's...

Can anyone tell me if they know how to create a DSN-less connection that uses SQL login security rather than NT authentication. For reasons relating to the security scheme...