Solved

ActiveX Component can't create Object!

Posted on 2000-03-30
15
196 Views
Last Modified: 2010-05-02
I have a VB6 application that uses Access libraries.  It works fine on all machines but 1.  THe installation program seems to be working but on one machine I install the application on; it is not working.  I get ActiveX Component can't create ObjectError #429.
I determine that the error is coming from the set ac= new Access.application.

Please help
Paul
0
Comment
Question by:kdddb
  • 4
  • 3
  • 3
  • +3
15 Comments
 
LVL 2

Expert Comment

by:bhamilto
Comment Utility
You can get this error if the version of the referenced object is out-dated.
0
 
LVL 20

Expert Comment

by:hes
Comment Utility
Is Access installed on the problem PC ?
If not see here for an explanation

http://support.microsoft.com/support/kb/articles/Q189/3/66.ASP
0
 
LVL 4

Expert Comment

by:gcs001
Comment Utility
It could also be that one (or more) of your DLL's in your setup package is not being installed on this user's PC for some or other reason

You would have to check the DLL's in your package and compare them to the DLL's on the user's machine to see if they are all there or not.

If one isn't it may be as easy as copying the correct DLL across to the user's machine and running REGSVR32 against the file to register it.

Regards,
Grant.
0
 
LVL 69

Expert Comment

by:Éric Moreau
Comment Utility
You definitely need to install Access on user's PC before running it!
0
 

Author Comment

by:kdddb
Comment Utility
To bhamilto:
   How do I get a updated version?

To Hes:
   I tried what the that website said and I still get that error.

To qsc001:
   Yes, during the setup I did get 2 dll that didn't copy because they were being used by windows and I got a can't register an dll error. So I tried to manually register the dlls and I got errors.  I even copied the dlls off the development machine and tried to register them and I still get the same can't register dll error.

HELP
0
 
LVL 4

Expert Comment

by:gcs001
Comment Utility
Did you get the same problem (registering DLL's) on the other PC's where the app works?
Exactly which DLL's were problematic in the setup?
0
 
LVL 69

Expert Comment

by:Éric Moreau
Comment Utility
PDW doesn't install Access even if it is referenced. Is Access already installed on the user's PC?

Also, download and install SP3 of VB. It corrects a lot of problems in PDW.
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 2

Expert Comment

by:bhamilto
Comment Utility
Re updated version

Have you confirmed that the Access version is different on the problem machine?

If the major release is different (95,97,2000) obviously an upgrade must be purchased.  If its a minor upgrade, a free service pack may be available on the MS site.

Note also that if your app will work with older versions of Access, you should be able to compile it on a machine with the older version allowing it to work with that and all newer versions.
0
 
LVL 2

Expert Comment

by:bhamilto
Comment Utility
Re updated version

If DLLs are missing then "version" is meaningless.

If the DLLs are present then you may have a version problem:
Have you confirmed that the Access version (or associated DLL's) is different on the problem machine?

If the major release is different (95,97,2000) obviously an upgrade must be purchased.  If its a minor upgrade, a free service pack may be available on the MS site.

Note also that if your app will work with older versions of Access, you should be able to compile it on a machine with the older version allowing it to work with that and all newer versions.
0
 

Author Comment

by:kdddb
Comment Utility
To qsc001:
   Actually Yes.  On all the machines I got the same can't copy files error and can't register dll error, but the application works fine.

The dll that could be copied mfc42.dll and msvcrt.dll.  Can't register dll is expsrv.dll.

I also install mdac_typ.exe-- it installs the latest Microsoft(R) Data Access Components 2.1.

0
 
LVL 69

Expert Comment

by:Éric Moreau
Comment Utility
>The dll that could be copied mfc42.dll and msvcrt.dll.  
Do you have a line in your autoexec.bat or login script that delete the contents of your temp folder?

>Can't register dll is expsrv.dll.
This is a typical symptom that you haven't installed SP3. This one is not important.

>I also install mdac_typ.exe-- it installs the latest Microsoft(R) Data Access Components 2.1.
BTW, the latest MDAC is 2.5 and won't help in creating an Access instance!
0
 

Author Comment

by:kdddb
Comment Utility
To qsc001:
   Actually Yes.  On all the machines I got the same can't copy files error and can't register dll error, but the application works fine.

The dll that could be copied mfc42.dll and msvcrt.dll.  Can't register dll is expsrv.dll.

I also install mdac_typ.exe-- it installs the latest Microsoft(R) Data Access Components 2.1.

0
 

Accepted Solution

by:
buckt earned 50 total points
Comment Utility
The problem is OLEAUT32.dll.  Check your versions on this and compare.  kdddb is correct though.  Installing the latext mdac_typ.exe will take care of this as it updates oleaut32.dll as well.
0
 
LVL 4

Expert Comment

by:gcs001
Comment Utility
Service Pack 3 resolves the problem with the registration of expsrv.dll.
0
 

Author Comment

by:kdddb
Comment Utility
Most of the responses were somewhat correct.   I thought if I use Access libraries I don't have to install access.  Is that not one of the purposes of using Active X controls.  I solve my problem I had to install Access on the machine.  Thanks qsc001,hes, bhamilo,emoreau.




0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
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 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…
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…

771 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

13 Experts available now in Live!

Get 1:1 Help Now