Solved

Received error "ActiveX component can't create object" while calling WinFax.SDKSend in VBA

Posted on 2004-08-02
5
506 Views
Last Modified: 2008-03-17
I've just upgraded to WinXP o/s from WinNT. My Access database which calls the WinFax (WinFax Pro version 10) SDK failed with a run-time error "ActiveX component can't create object". Because of this error, I've taken the following steps of action, yet the error remains:
1. Upgraded the database to Access 2002 from Access 2000.
2. Compiled the modules successfully.
3. Checked the library references - all are linked (no MISSING).
4. External library dlls modules are correctly registered with regSvr32.
5. Steps in Microsoft Knowledge Base 319841 have been follow through.
6. Checked to use the latest service pack and versions (DAO 3.6, ActiveX data object 2.8, OLE Automation, Winfax Automation Server, Symantec Winfax Pro Control)

Please advice; what is the solution?
 
The VBA line of code that caused the error #429 - "ActiveX component can't create object" follows:

    Set objWFXSend = CreateObject("WinFax.SDKSend")     '<---  Late Binding

Thanks,
Alice
0
Comment
Question by:AliceEng
  • 2
5 Comments
 
LVL 27

Expert Comment

by:jjafferr
ID: 11701815
Another user had a problem with WinFax, you can see it here
http://www.experts-exchange.com/Applications/Q_20942955.html#10752002

Please read the whole thread to get a better picture of what happened, and don't be decieved by the title.

jaffer

0
 

Author Comment

by:AliceEng
ID: 11709624
Hi,
Thanks for the reference. However, I've already uninstalled and re-installed WinFax Pro, same error exists.
Can anyone tell me if a later version of WinFax Pro SDK package (beyond v10.2) that will handle Windows XP OS complacently?
Regarding the environment of this application:
1. The Operating System is WinXP.
1. Front-end user interface is written in MS Access 2002.
2. Back-end database is SQL Server 2000.
3. Application uses ODBC connection and DAO (it is not an Access Project, and doesn't use ADO)
4. A front-end Access Report event procedure fires a call to the VBA Fax module passing the report image along with the fax#, title, description, cover page, and other required fax elements.
5. The front-end Access VBA function calls the Symantec SDK DLL objects and initiates a Fax session. When the code CreateObject("WinFax.SDKSend") is executed at run-time, the error handler returns the error# 429 with the message “ActiveX component can’t create object”.

Regarding the history:
1. At the days of WinNT O/S, MS Access 2000, and SQL Server 2000, the Fax application operates normally, slow at time, but completes successfully and automatically in sending more than 90 faxes (= 90 reports) to different fax numbers across the country.
2. Now under WinXP O/S with the same application environment as stated above, the system errors out.  Users have to manually print-preview an Access Report and print it to the Fax device instead of the printer.  With the manual method, users must repeat the report print process 90 times. Frustration mounts; it takes days instead of minutes to perform the same function.

Any help will be most appreciated,
Alice.
0
 
LVL 27

Accepted Solution

by:
jjafferr earned 500 total points
ID: 11712740
Hi Alice
I don't know how much this will help, but its worth reading,
I was answering another question regarding dialog browser,
when I gave the asker the code and later I sent a working mdb,
s/he kept getting the same error as yours: error# 429 with the message “ActiveX component can’t create object”
http://www.experts-exchange.com/Databases/MS_Access/Q_21078927.html

So this makes me think:
There must be an ActiveX component that was installed on the WinNT pc which is not installed on the WinXp pc,
and it doesn't show in the Reference, but WinFax depends on.

Did you mean to say that users are still using WinFax but manually?
If you change the default printer to the Fax device and print, will that solve your problem?
check in www.lebans.com for a default printer code,
which will change the default printer in your mdb, then revert to the original when you quit.

jaffer
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Password on a button in Access 2013 7 35
DSum for Access 6 46
Error in query expression 3 36
Error in Rs.MoveNext & Duplication of Record 14 25
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

920 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