Solved

Run-time error '430' : Class does not support Automation or does not

Posted on 2002-06-15
8
716 Views
Last Modified: 2010-05-02
I've made a program in Vb6 when the database is on access 2000.
i've made an exe file and also made a setup file using the program setup specialist.
when i'm trying to run my prog on a computer that doesn't have vb installed i get the message "Run-time error '430' : Class does not support Automation or does not support expected interface"
i haven't made any new class for myself - in the project references i have word, access, outlook etc.
what can i do to run it on a computer with no vb????

please refer your answers to tweety2@inter.net.il as well as in the site.
Thanks a lot,
Yael
0
Comment
Question by:tweety2
[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
8 Comments
 
LVL 4

Expert Comment

by:RichW
ID: 7080716
http://www.microsoft.com/downloads/release.asp?releaseid=28337&area=top&ordinal=23

Download the VB 6 runtime files.  Load them ont he machine that doesn't have VB loaded.  Your program will then run.

RichW
0
 
LVL 22

Accepted Solution

by:
Mohammed Nasman earned 100 total points
ID: 7080758
Hello

  also this error may happned if MDac not installed in the client machine, you can download the mdac from

www.microsoft.com/data
0
 
LVL 16

Expert Comment

by:Richie_Simonetti
ID: 7081102
That's appears as version problem.
If you are using objects from Access, Word, Outlook, etc, End user machines must have those apps installed. It is not enought with TLBs only.
0
Technology Partners: 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!

 
LVL 16

Expert Comment

by:Richie_Simonetti
ID: 7081105
Also take a look at wich version of office you have in development machine and end user one.
If you are using, in example, Word 2000 and end user has, also in example, Word95/97, some methods/constants and other stuff from Word 2000 are not present in older versions.
0
 

Author Comment

by:tweety2
ID: 7081206
to Richie Simonetti
thanks for the comment, but the user and the end user has the same version of word, access and outlook, so it doesn't seem to be the problem.
0
 
LVL 44

Expert Comment

by:bruintje
ID: 7081233
this is probably not be the problem, but i would never distribute code containing hard references to office objects in a solution even if your're sure they're the same

-always develop with the references so you can use things like

dim objXL as Excel.Application

-and have the auto completion help you

-but distribute without references and code like

dim objXL as Object

-so you're not depending on versioning SP's etc.. on te client machine

HAGD:O)Bruintje
0
 

Author Comment

by:tweety2
ID: 7081279
to bruibtje
thanks, i did refer as x.application
0
 

Author Comment

by:tweety2
ID: 7081281
thanks
it worked wonderfully!
:O)
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
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…
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…

695 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