V
Van T. Dinh
If you use DSN for your linked Tables, check the settings
of your DSN in the Data Source (ODBC) of your Windows set-
up.
OTOH, "SA" should NOT be used for accessing SQL Server
data. Most SQL books advise against using "SA" for
anything other than SQL Server administration. You can
create a Application User in SQL Server and use the SQL
Server authentication rather than Windows NT
authentication.
HTH
Van T. Dinh
MVP (Access)
of your DSN in the Data Source (ODBC) of your Windows set-
up.
OTOH, "SA" should NOT be used for accessing SQL Server
data. Most SQL books advise against using "SA" for
anything other than SQL Server administration. You can
create a Application User in SQL Server and use the SQL
Server authentication rather than Windows NT
authentication.
HTH
Van T. Dinh
MVP (Access)