[DBNMPNTW]Specified SQL server not found.

[Mike W.]

....is the message I get when trying to connect to a
product database on Access 2000 running on Win2k SP4.

The interesting thing is, I've been able to connect no
problem on another user's computer, also running Access
2000 - but on WinXP Pro.

Short of installing XP Pro, is there anything I can try to
get it to work on _this_ computer?

Thanks kindly for any help.

 

[Mike W.]

Just finished reformatting & reinstalling Win2k SP4 &
Office2k...no change.

Any suggestions?

 

[Mike W.]

Installing MDAC v2.8 did the trick.

It's a wonder that this issue isn't documented in a KB
somewhere, as you'd think that Win2k & Access2k are a
pretty common combination.