When running MDAC 2.0 or 2.1 on IIS 4.0 the speed of accessing Access or SQL
data fall's through the floor, a report that used to take 16 seconds would
take 2 mins 43 seconds. Having spoken to Microsoft I have had to revert to
MDAC 1.5 and this was not easy. However this now leaves me with the problem
of Access 2000 and SQL 7.0. I have heard tale of a mythical version 2.2 from
the support person at Microsoft however no one seams to know how to get hold
of it or even if it does exist.
Is it possible to :
1) Fix the speed Issues with MDAC 2.1 or MDAC 2.0
2) Get hold of the Mythical MDAC 2.2
3) Get MDAC 1.5 to work with SQL 7.0 and Access 2000.
4)Are these issues resoved with Windows 2000 and IIS 5.0.
Pathtrace PLC (UK)