>Yes, if it's not on the SQL Server you'll need to give the user access to the network. I don't think there's a way to have the ODBC driver dial the network. You can either have the user dial in manually using dial up networking or you could have your application use dial-up networking to connect before it tried to access the remote data. I think there are some classes in the file section here to make calls using DUN. If not, take a look at Rick Strahl's wwipstuff. It's free from www.west-wind.com.

Thanks again. I will check out those resources.