I put mdac 2.6 sp1 on my clients running vb6 sp5 program compiled with
reference to microsoft data access 2.5.
When I log on as me (sql admin), I can connect to all servers.
When I log on a user box as the client, they can't connect to sql 7
but can connect to sql 2K.
win2k won't let me take off mdac 2.6 or reinstall mdac 2.5.
MSDN has no fixes that I can Find.
I noticed Serge Shakhov has some success with sql 2K.