?
Solved

VBAJet.dll failed to initialize

Posted on 1999-01-03
7
Medium Priority
?
2,120 Views
Last Modified: 2013-12-25
.  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 application that returned the error. (Error 3447)  

I have the above error when I installed and run my application in my employer’s machine. All other machines I used to test it worked fine. I copied the file VBAJet32.dll
in c:\windows\system and I still get the same problem.
I use VB5 and Microsoft Access and I must solve this error
to allow my client to use the program.
I need help immediately. Please help.
I reinstalling the application many times but no luck
thank you
 
0
Comment
Question by:yassin092898
[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
  • 3
7 Comments
 
LVL 4

Accepted Solution

by:
CraigLazar earned 400 total points
ID: 1498658
Hi
Had this problem , check that you have the expsrv.dll file on the target pc or goto to sysinternals.com and download filemonitor adn it will tell you which dll is needed to initialize the vbjet.dll properly

C
0
 

Expert Comment

by:iw
ID: 1498659
I also get this error with a VB5 application.  I think the new dll's conflict with previous versions.  For instance, my machine has VB6 on it and I always get data access errors with my VB5 applications.  

Do you install support files into the application directory?  If so, copy the versions of VBAJet32.dll and msjet35.dll (if necessary) that exist in their Windows system directory (or in another place in their path) into your app directory, deleting your versions (actually, rename them--always good to be able to backtrack) and then launch the app.  That solves the problem for my users, but I install my support files into the application directory.

Good luck,

ian
0
 

Author Comment

by:yassin092898
ID: 1498660
I was using VB5 first and I switched VB6, after having some
difficulties I switched back to VB5. I reformatted my hard drive
and I reinstalled Vb5 and an old VB5 version of my application.
The problem with my user's computer is I run the VB6 version of
my application and after that it refused to run my VB5 application any more giving me the above error message.
Now I can't go to my users office and do many tests, because I
am still in college and I don't want to disturb them with many
visits to their office instead I would like to go there with
a clear idea and a solution.
I must tell you that I never programmed more than an academic project
and never in windows environment, Visual Basic and Microsoft
Access. I just learned as I was writing this application.
Now the application is done and it runs Ok with all machines
except the one it matters.
I would appreciate if you kindly be specific and guide me step
by step as a beginner. I would also like a way I create the error
in my machine so that I can fix it before I go to my employers office.
I increased the points and I shall increase more if necessary.

I would like to tell CraigLazer that I don't have the file
expsrv.dll in my computer and in my laptop but the program runs Ok in both computers.
In my laptop, I don't even have VBAjet32.dll. What is going on?
On the other hand why do I need VBA5jet32.dll is it for MS jet engine. I am not doing any VBA programming.

I downloaded Filemonitor but all I can see is processes and
unfortunately, my program never dies even when I exit it.
I am very sorry for the may questions, but I hope the I shall
learn a lot in this question and you will understand my frustration.
Thank you.

0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:yassin092898
ID: 1498661
Adjusted points to 100
0
 
LVL 4

Expert Comment

by:CraigLazar
ID: 1498662
Hi Yassin
Let me see if I understand this correctly .
You have an app which is created in vb5 and it sounds like you ar connecting to an access database . The app however does not work on your employers PC . If this is so then what you can also try is try to pin point were the error comes up . Is it when you try to start the app , or go to a certain form ect . Then try putting in a whole lot of message boxes in the area u are getting the error . Say the function that is giving you the problems what u do is put a msgbox"1" after each line of code to nail down which line of code is giving you hassels .

Also check the filemonitor you can use the filter which means u can specify which path and process it must monitor . this will help so u do not have to go thru all the stuff you do not need .

Iam throwing ideas around , if u do not come arite mail me the project and i will take a quick look (clazar@softnet.co.za)

good luck

Craig

0
 
LVL 4

Expert Comment

by:CraigLazar
ID: 1498663
Hi Yassin
Let me see if I understand this correctly .
You have an app which is created in vb5 and it sounds like you ar connecting to an access database . The app however does not work on your employers PC . If this is so then what you can also try is try to pin point were the error comes up . Is it when you try to start the app , or go to a certain form ect . Then try putting in a whole lot of message boxes in the area u are getting the error . Say the function that is giving you the problems what u do is put a msgbox"1" after each line of code to nail down which line of code is giving you hassels .

Also check the filemonitor you can use the filter which means u can specify which path and process it must monitor . this will help so u do not have to go thru all the stuff you do not need .

Iam throwing ideas around , if u do not come arite mail me the project and i will take a quick look (clazar@softnet.co.za)

good luck

Craig

0
 

Author Comment

by:yassin092898
ID: 1498664
Hi Craig
I remember the last time I had this problem it was comming from
the database. I'll go this weekend and find out where the problem
is comming from. But I am closing this question and I shall let
you know the outcome by the weekend.
Thank you very much for the help.

yassin
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

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
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
Course of the Month12 days, 8 hours left to enroll

777 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