MDAC Versioning



Hi,

I administer several Access/SQL Server databases for a hospital Trust, that
use a combination of ODBC linked tables and ADO.

MDAC has proved to be an occasional bugbear, as sometimes the dlls don't
work correctly and a database will produce errors like "Open Method of
connection failed" and "Provider cannot be found". The typical solution for
this is to install a later version of MDAC.

The problem is, if the version on the machine is the same as being installed
(typically 2.7 or 2.8) then the setup program will not overwrite the dlls. I
used to be able to get round this by running the dasetup.exe program to roll
MDAC back and then reinstall. Lately, I can't do this as I keep getting
"Fatal Error Loading EULA file" while attempting to run dasetup. I have
suspicions that something has been installed on the network which is
preventing the program working.

The component checker isn't proving helpful, as this only provides an
inventory of the dlls.

Does anyone have either of the following solutions :

1) A remedy for the EULA file error or possible path of investigation?
2) Another method of forcing MDAC to reinstall over the current version?

Thanks in Advance
Jim

.