I have searched this site but nothing I have come across helped me solve this problem.
With no experience I managed to set up MSDE on one of our servers. Our Microsoft Access guru has been working with it and one of his databases is now operational.
Every user is able to connect without any difficulty except one user who is running Windows 2000 Professional. All other people running WIN2K and XP connect without any problems.
The server SQL is running on is Wndows 2003 Server
ODBC --connection to 'SQL ServerSERVERNAME\Instance' failed
The user gets this error message when he attempts to open the Access Database.
Where can I start looking? Any suggestions?