What I think I need to do is create an ODBC connection between a computer that has the Access file and the computer running the SQL Server.

We have our SQL server configured to only allow Windows accounts (i.e. not mixed). However, in some cases we are connecting from non-domain boxes and we want to specify a domain account to connect ...

Windows 7 includes an ODBC manager that lets you connect from your desktop to a SQL server. You create a data source name (DSN) to save database setup information, so you can open a connection to ...