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.
Personally, I would create a SQL Server system DSN on your PC using that IP address and user credentials (in ODBC administrator).
For a DSN-less connections, you might like to look at this Support.Microsoft
This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…