PRB: Mismatched Jet DLL Files with Excel and Visual Basic (148177)



The information in this article applies to:

  • Microsoft Visual Basic Standard Edition, 32-bit, for Windows 4.0
  • Microsoft Visual Basic Professional Edition, 16-bit, for Windows 4.0
  • Microsoft Visual Basic Professional Edition, 32-bit, for Windows 4.0
  • Microsoft Visual Basic Enterprise Edition, 16-bit, for Windows 4.0
  • Microsoft Visual Basic Enterprise Edition, 32-bit, for Windows 4.0
  • Microsoft Excel for Windows 95

This article was previously published under Q148177

SYMPTOMS

If you install Microsoft Excel from a network server and then install Visual Basic 4.0, you may run into an error message that you cannot create a workspace and that you need to check the installation of VBAJET32.DLL.

CAUSE

The error message is the result of mismatched files. The Microsoft Excel setup program installs the Jet/VBA files on to the network system directory while Visual Basic setup program installs the Jet/VBA files on to the local system directory.

RESOLUTION

To work around this problem, copy the Jet/VBA files installed by Visual Basic located on the local system directory to the network system directory.

STATUS

We are researching the problem and will post more information here in the Knowledge Base as it becomes available.

MORE INFORMATION

This problem occurs only if Microsoft Excel is installed first, followed by the Visual Basic installation. The problem does not occur when Visual Basic is installed by itself.

Modification Type:MinorLast Reviewed:8/18/2005
Keywords:kbprb kbProgramming kbsetup KB148177