The Jet VBA File VBAJet32.dll Failed to Initialize - Causes Runtime Error 3447

From Support

If you have a question or seek clarification, please call Technical Support.

Problem:

SYMPTOMS If you created a setup program for a DAO application using Visual Basic 5.0 or Visual C++ 5.0 and you upgraded to version 6.0 of those products, you will receive the following runtime error (3447) when you attempt to run the application on a distributed computer:

The Jet VBA file (VBAJet.dll for 16-bit versions, or VBAJet32.dll for 32-bit versions) failed to initialize when called. Try reinstalling the applications that returned the error.

CAUSE Applications like Visual Basic 6.0 and Visual C++ 6.0 install new versions of the DAO and Jet files on your development computer. Any version of VBAJet32.dll 6.0.1.8132 or later is now dependent on the file Expsrv.dll. The error occurs with your original setup program because it does not include Expsrv.dll in the dependency information.

Solution:

MICROSOFT KNOWLEDGEBASE ARTICLE LINK http://support.microsoft.com/support/kb/articles/q196/0/57.asp

RESOLUTION To resolve the error, do one of the following:

Manually add Expsrv.dll to your file list for your existing setup program.

Re-create a new setup program from scratch that includes this new dependency.

RJS SPECIFIC RESOLUTION EXPSRV.DLL can also be copied to the WINDOWS\SYSTEM or WINNT\SYSTEM32 directory from the RJS Software Systems installation CD. It can be found in the FREE\EXPSRV directory on the RJS CD.

MORE INFORMATION Steps to Reproduce Behavior Create a DAO application and redistribution using Visual Basic 5.0 or Visual C++ 5.0.

Upgrade the computer to version 6.0 and rebuild your setup file.

Run the version 6.0 setup on a clean computer.

RESULT: When you try to run the application, you receive run-time error 3447.