Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

the Jet VBA file

Posted on 1999-07-19
4
Medium Priority
?
530 Views
Last Modified: 2012-05-04
Hi,
   I have developed an application using VB6.0 and MS Jet 4 as database.I had created an setup program and then i installed the application on another device.when i tried to run the application it gives me this error message "The JetVBA file (VBAJET.dll) for 16-bit version or VBAJET32.dll for 32-bit version failed to initialize when called".
when i trying to see the Q.192934 the question was removed from the experts, Please someone solve the problem
Eman
0
Comment
Question by:Eman
[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
4 Comments
 
LVL 13

Expert Comment

by:Mirkwood
ID: 1525846
Before you go trought with your question, you must know about VBJet16.dll and JET system itself.

Jet is a system to control SQL database. Without this JET, any database control can't be done perfectly.

When installing program/software using Jet, they want to control their SQL database.

MSAccess / DBASE 4 Win / VB using SQL need this file to control that system it'self.

In VB5/VB6, it use VBJet16.dll to control this their SQL.

To solve your answer :
- Please check any JET user using VBJet16.dll...
Close that program if you can.. include TSR.
- Close any DBASE or ACCESS using another SQL Jet system.

Coz... In instalation procedures, this VBJet16.dll must overwite and Setup operation not complete if this file has been use by other SQL user. So U must free the VBJet16.dll to allowed SETUP deleted or overwrite and use this file in their setup.

0
 
LVL 13

Expert Comment

by:Mirkwood
ID: 1525847
Make sure that ODBC is installed otherwise try

Download Filemon or NTFilemon from www.sysinternals.com 
Start Filemon and now run the application that gives the error.
Filemon will show a trace. In this trace it will also show you which
file failed to open. That's the one you are missing.

0
 
LVL 13

Expert Comment

by:Mirkwood
ID: 1525848
I keep forgotten the correct answer to this question.
It's one of the following below:
-You have installed both VB5 & VB6. Uninstall one of them. See Q192934 of the MSDN
-MFC dll's are wrong (version 7128). See Q192934 of the MSDN

0
 

Accepted Solution

by:
ccjh earned 300 total points
ID: 1525849
PRB: Error "The Jet VBA File...Failed to Initialize When Called"

--------------------------------------------------------------------------------
The information in this article applies to:

Microsoft Visual Basic Professional and Enterprise Editions for Windows, versions 5.0, 6.0

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


SYMPTOMS
When you run an application that uses Microsoft DAO, you receive the following error message (run-time error 3447):



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
The Microsoft DAO or Jet files are mismatched, or one or more of the DAO or Jet files is missing.

This error most commonly occurs when you deploy a Visual Basic 5.0 application from a development computer that has the Visual Studio 6.0 versions of the DAO and Jet files installed. The Jet files that come with the Visual Studio 6.0 products require an additional file, Expsrv.dll. Because the Vb5dep.ini file does not include this file in the dependency information for Jet, the Visual Basic 5.0 Setup Wizard does not include Expsrv.dll in the Setup files for your application.



RESOLUTION
Use one of the following resolutions, depending upon your situation.

Expsrv.dll Is Missing from Setup Files
If you are deploying a Visual Basic 5.0 application from a development computer that has the Visual Studio 6.0 versions of the DAO and Jet files installed, you can work around the problem by adding Expsrv.dll in the File Summary screen of the Setup Wizard. However, you might encounter problems distributing other updated components.

The safest alternatives are as follows:
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).

-or-


Download and install the latest MDAC components from:

http://www.microsoft.com/data/

Then run the setup for your application again.





Other DAO or Jet Files Are Missing or Mismatched
According to the master list of dependency files for Visual Basic 5.0 and 6.0 (Vb5dep.ini and Vb6dep.ini, respectively), the following files are required for DAO and Jet. Check for these files with the appropriate version numbers on the computer where the error occurs.

If you distribute an application using a Setup created by the Setup Wizard or Package and Deployment Wizard, you also need to check the file Setup.lst to verify the appropriate files and file version numbers. Setup.lst is the master list of the files that are installed by the application setup. You can find Setup.lst in the folder that contains the setup files for your application.

NOTE: All of these files are located in the \Windows\System (or on Windows NT, in the \Winnt\System32) folder, except DAO350.dll. The DAO350.dll file can be found in the \Program Files\Common Files\Microsoft Shared\DAO folder.
Visual Basic 5.0 Files and Version Numbers:
DAO350.dll     3.50.3602.0
MSJet35.dll    3.50.3602.4
MSJInt35.dll   3.50.3602.5  
MSJtEr35.dll   3.50.3602.0  
MSRD2x35.dll   3.50.3602.0
MSRepl35.dll   3.50.3602.0  
MSVCRT40.dll   4.10.6038 or later
VB5DB.dll      5.00.3724
VBAJet32.dll   5.0.7122
Visual Basic 6.0 Files and Version Numbers:
DAO350.dll     3.51.1608.0
ExpSrv.dll     6.0.8167
MSJet35.dll    3.51.0623.4
MSJInt35.dll   3.51.0623.0
MSJtEr35.dll   3.51.0623.0
MSRepl35.dll   3.51.0623.0
MSRD2x35.dll   3.51.0623.0
MSVCRT40.dll   4.21.0000 or later
VB5DB.dll      6.00.8169
VBAJet32.dll   6.1.8167


For more information about the files installed for each version of Jet, please refer to the following article in the Microsoft Knowledge Base:

Q178880 INFO: Identifying the Jet Database Engine Components


If you determine that the version of a file on the system is incorrect, perform the following steps to replace it. If you determine that a file is missing, skip to step 3.


If the file is one that requires registration (MSRD2x35.dll, MSJet35.dll, or DAO350.dll), perform the following steps to unregister it:


On the taskbar, click the Start button, and then click Run.


In the Run dialog, type the following command:
Regsvr32.exe /u <DLL Name>
where DLL Name is the name of the DLL file, such as DAO350.dll.


Click OK.


Rename the mismatched file.


Copy the appropriate version of the mismatched or missing file from the Visual Basic produce CD to the computer experiencing the problem.

NOTE: For Visual Basic 6.0, all the files are located in the OS\System folder on Disk 1.

For Visual Basic 5.0, all the files, except DAO350.dll, are located in the OS\System folder on the Visual Basic CDs and the VB5.0\OS\System folder on the Visual Studio 97 CDs. DAO350.dll is located in the OS\MSAPPS\DAO folder on the Visual Basic CDs and the VB5.0\OS\MSAPPS\DAO folder on the Visual Studio 97 CDs.


If the file is one that requires registration (MSRD2x35.dll, MSJet35.dll, or DAO350.dll), register it using the following steps:


On the taskbar, click Start, and then click Run.


In the Run dialog box, type the following command:


Regsvr32.exe <DLL Name>
where DLL Name is the name of the DLL file, such as DAO350.dll.


Click OK.


As an alternative solution, you can run the DAO SDK redistribution setup on the target computer that has missing or mismatched DAO or Jet files. The DAO SDK redistribution is provided in the DAOSDK\REDIST folder on Disk 1 of Visual Studio 6.0 Professional Edition and Disk 3 of Visual Studio 6.0 Enterprise Edition. It consists of three folders -- Disk 1, Disk 2, and Disk 3. You can either run Setup.exe from the Disk 1 folder on the CD, or you can copy each of the folders to a diskette and run Setup.exe from the first diskette.



MORE INFORMATION
If you have multiple versions of Visual Basic or Visual Studio on the same computer, it typically does not alter the development environment. However, regarding application deployment, multiple versions can cause a Visual Basic application to fail to install correctly. This can be caused by newer versions of components that exist on the computer and the inability of the installation application to correctly determine dependency information or register those components. To ensure good distribution of your application, the development machine should have only the necessary version of Visual Basic or Visual Studio installed.

For additional information, please see the following article in the Microsoft Knowledge Base:

Q193270 INFO: Troubleshooting VB Application Installation Issues



REFERENCES
For additional information, please see the following articles in the Microsoft Knowledge Base:

Q196057 PRB: The Jet VBA File VBAJet32.dll Failed to Initialize


Q191735 PRB: The Jet VBA File Failed to Initialize When Called




Additional query words: distribute deploy

Keywords          : kbwizard kbAppSetup kbVBp500
Version           : WINDOWS:5.0,6.0
Platform          : WINDOWS
Issue type        : kbprb
 


Last Reviewed: April 27, 1999
) 1999 Microsoft Corporation. All rights reserved. Terms of Use.
 

 

Article ID: Q192934

Last Reviewed:
April 27, 1999

Provided by Support Online from Microsoft Product Support Services.




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

      Did the information in this article help answer your question?
Yes
No
Did not apply

Please provide additional comments about this information. If you require a response or technical support, please click Contact Us.
(255 character max)

 


 
 
 

0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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…
Suggested Courses

670 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