[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

VBAJet.dll failed to initialize

Posted on 1999-01-03
7
Medium Priority
?
2,172 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
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

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…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses

865 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