PRB: Mismatched Jet DLL Files with Excel and Visual Basic
Article ID: 148177
Article Last Modified on 8/18/2005
APPLIES TO
- Microsoft Visual Basic 4.0 Standard Edition
- Microsoft Visual Basic 4.0 Professional Edition
- Microsoft Visual Basic 4.0 Professional Edition
- Microsoft Visual Basic 4.0 16-bit Enterprise Edition
- Microsoft Visual Basic 4.0 32-Bit Enterprise Edition
- Microsoft Excel 95 Standard Edition
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.
Additional query words: Excel95 XL7
Keywords: kbprogramming kbsetup kbprb KB148177