Solved

vbajet.dll not initializing?

Posted on 1999-01-26
5
268 Views
Last Modified: 2013-12-25
I installed trial versions of this app before.  Suddenly, on machines that ran previous versions fine, I get a runtime error VBAjet.dll or VBAjet32.dll not initializing.  I checked the system folders, and both dll's are in there.  Why is this happening?  I reinstalled that app, too, to see if that would work. Nope.  What do I need to take care of, here?  Thanks for help.
0
Comment
Question by:RUSTY
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 13

Accepted Solution

by:
Mirkwood earned 60 total points
ID: 1499465
PRB: Error "The Jet VBA File...Failed to Initialize When Called"
Last reviewed: September 28, 1998
Article ID: Q192934
 


--------------------------------------------------------------------------------

The information in this article applies to:
Microsoft Visual Basic Professional and Enterprise Editions for Windows, version 5.0, 6.0


SYMPTOMS
After installing a Visual Basic 5.0 application on an end user's computer, the run-time error 3447 is received when it is executed:


   "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."

This occurs when the application is created on a machine with both Visual Basic 5.0 and 6.0 installed and the setup program for the Visual Basic 5.0 application is created using the Visual Basic 5.0 Application Setup Wizard.


CAUSE
Visual Basic 6.0 installs new versions of the DAO and Jet files on the development computer. The version of VBAJet32.dll (6.1.8167) that comes with Visual Basic 6.0 is dependent on Expsrv.dll, but the Visual Basic 5.0 Setup Wizard does not include this file because it is not included in the dependency information in VB5Dep.ini.



RESOLUTION
You can attempt to work around the problem by adding Expsrv.dll in the File Summary screen of the Setup Wizard. However, you may run into problems distributing other updated components as well.

Following are the safest alternatives:

Develop and create setup files for your Visual Basic 5.0 application on a "clean" computer. (See the MORE INFORMATION section later in this article.)
-or-

Upgrade the application to Visual Basic 6.0 and create the setup files using the Package and Deployment Wizard (PDW).

MORE INFORMATION
For the most part, having multiple versions of Visual Basic on the same machine does not alter the development environment. With regards to application deployment however, having multiple versions can cause the application to not install correctly due to newer versions of components and the inability of the installation application to correctly determine dependency information and/or register these components. To ensure a good distribution of the application, the development machine should have only the necessary version of Visual Basic installed.
 

0
 

Author Comment

by:RUSTY
ID: 1499466
I installed VB6 to see and possibly to port my app up to it.  Decided not to, so uninstalled VB6 and reinstalled VB5.  I intend to continue developing in VB5.  Do I need to format my whole hard drive and start over, or can I delete some files in the registry or system folder and replace them?  
0
 
LVL 13

Expert Comment

by:Mirkwood
ID: 1499467
Reinstall DAO again using VB5.
0
 

Author Comment

by:RUSTY
ID: 1499468
Doesn't seem to matter.  I still have VBAJet32.dll ver 6.1.8167 in the system folder.  If I could download or somehow get the VB5 version of the vbajet.dll's, would it work to just replace them in my system folder?
0
 

Author Comment

by:RUSTY
ID: 1499469
Are there other files that will have problems now, too?
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question