Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2002-06-15
8
Medium Priority
?
777 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 400 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

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…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…
Suggested Courses

604 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