Solved

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

Posted on 2004-08-02
5
511 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
[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
  • 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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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…

751 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