Solved

My VBAJET32.DLL is not working

Posted on 2001-08-11
5
217 Views
Last Modified: 2013-12-28
I have a government program called the knowledge center. One of the function of the program is to export data to EXCEL. The error when exporting is:

The Jet VBA file (VBAJET.dll for 16-bit versions of VBAJET32 for 32-bit versions) failed
to initialize when called. Try reinstalling the application that returned the error. (3447)

The environment is:

Windows NT 4
MS Office 2000
IE 5.5
with current patches

I reloaded office
I reloaded IE 5.5 and redid the patches
I reloaded SP6a for NT
The knowledge center client software has been reloaded.
The file in question exists and has been replaced individually.

The problem only occurs on one version of computer. There are two computer in the area.
One is a Compaq and one is a generic with standard HCL acceptable parts.

The program exports on the Compaq but fails on the generic. I don't want to reimage these machines.

What does VBA JET do?
Where is is found?
Is this a registry error?
Is the problem in Win NT or Office or IE?
0
Comment
Question by:Rhb
5 Comments
 
LVL 63

Expert Comment

by:SysExpert
ID: 6375631
1) Get the service pack for msoffice

2) Make sure that you installed the VBA stuff for excel. It may not be part of a standard install

3) Check the MS site for the error message you received !

I hope this helps !
0
 
LVL 15

Expert Comment

by:lyonst
ID: 6379657
Hi,

This should answer your problem..

http://support.microsoft.com/support/kb/articles/Q196/0/57.ASP

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

Cheers,

T.
0
 
LVL 15

Accepted Solution

by:
lyonst earned 200 total points
ID: 6379674
0
 
LVL 27

Expert Comment

by:Asta Cu
ID: 6907397
Please update the experts here who have so willingly stepped in to help you, since much time has passed since your last comments, and Email notifications may not have been generated to the participating experts here due to some problems at that time.  If you've been helped, accept the respective comment by that expert to grade and close it.

To see all your Open and Locked questions, click your member profile and View Question history to update/close them as well.

Somewhat off-topic, but important.

****************************** ALERT********************************
WindowsUpdate - Critical Update alert March 28, 2002 from Microsoft
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/bulletin/ms02-015.asp
Synopsis:
Microsoft Security Bulletin MS02-015  
28 March 2002 Cumulative Patch for Internet Explorer
Originally posted: March 28, 2002
Summary
Who should read this bulletin: Customers using Microsoft® Internet Explorer
Impact of vulnerability: Two vulnerabilities, the most serious of which would allow script to run in the Local Computer Zone.
Maximum Severity Rating: Critical
Recommendation: Consumers using the affected version of IE should install the patch immediately.
Affected Software:
Microsoft Internet Explorer 5.01
Microsoft Internet Explorer 5.5
Microsoft Internet Explorer 6.0

Thought you'd appreciate knowing this.
":0)
Asta
0
 

Author Comment

by:Rhb
ID: 6910048
We later found that the version of Office that was loaded on the computers in question had a number of problems. Several files had not loaded with the installation. We ended up removing and re-installing the Office product from a different version of the product. Although the option we used was to reload the whole product I did test the alternative suggestion about replacing one file and had some success. To many files were missing.

In general IVONST was the most correct. I still wish that I could give devided credit.

i apologize for not resolving this cas earlier.

Thanks for the help.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sccm report 1 38
lan speed when you have different speeds 5 49
Flashplayer.hta Download 1 28
Is there a driver update utility? 8 32
Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

932 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now