Solved

VBAJet.dll failed to initialize

Posted on 1999-01-03
7
1,970 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 100 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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

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…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
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…
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…

747 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

12 Experts available now in Live!

Get 1:1 Help Now