Run-time error 3706

[RobynG]

I am getting Run_time error '3706' "Provider cannot be
found" after updating Windows 2000 to SP4. Connection
string has been working for over a year and works with
other Access 2000 machines. Trying to use Jet 4.0 which
now comes with SP4.

 

[robyng]

Found the answer myself

Current release of Jet 4.0 SP7 contains 19 dll files (see
support.microsoft.com/default.aspx?kbid=282010). One was
missing from winnt/sys32 directory (Dao360.dll) but was in
W2K SP4 pack. Copied over manually, registered it with
regsvr32.exe, reregistered msjet40.dll, msjetoledb40.dll
for good measure, rebooted and all okay.

 

[Tony Toews]

Found the answer myself

Current release of Jet 4.0 SP7 contains 19 dll files (see
support.microsoft.com/default.aspx?kbid=282010). One was
missing from winnt/sys32 directory (Dao360.dll) but was in
W2K SP4 pack. Copied over manually, registered it with
regsvr32.exe, reregistered msjet40.dll, msjetoledb40.dll
for good measure, rebooted and all okay.

DAO360.DLL resides in "C:\Program Files\Common Files\Microsoft
Shared\DAO".

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm