If you're running a database that is linked to tables on SQL server your PC needs to have a copy of SQL server on it. You'll also need to have your ODBC settings set up so that the default system DSN is pointing to the database you want. Access, or whatever you're using, will then hook up to SQL Server using your ODBC DSN.