• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

ActiveX Component can't create Object!

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
kdddb
Asked:
kdddb
  • 4
  • 3
  • 3
  • +3
1 Solution
 
bhamiltoCommented:
You can get this error if the version of the referenced object is out-dated.
0
 
hesCommented:
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
 
gcs001Commented:
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Éric MoreauSenior .Net ConsultantCommented:
You definitely need to install Access on user's PC before running it!
0
 
kdddbAuthor Commented:
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
 
gcs001Commented:
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
 
Éric MoreauSenior .Net ConsultantCommented:
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
 
bhamiltoCommented:
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
 
bhamiltoCommented:
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
 
kdddbAuthor Commented:
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
 
Éric MoreauSenior .Net ConsultantCommented:
>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
 
kdddbAuthor Commented:
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
 
bucktCommented:
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
 
gcs001Commented:
Service Pack 3 resolves the problem with the registration of expsrv.dll.
0
 
kdddbAuthor Commented:
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

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.

  • 4
  • 3
  • 3
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now