I'm trying to connect Access 2000 to an MS SQL Server 2008 R2 table that exists on my LAN.
The machine is an XP Pro SP3 workstation.
Here's what I do:
Data Sources (ODBC)
Select: SQL Server Drive (SQL Native Driver 10 does not appear in the list)
Desripition:Test2 This is a test
Select: With WIndows NT autentication
Check: Connect to SQL Server to obtain default seetings...
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed. The login is from an untrused domain and can not be used with WIndows authentication.