Solved

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

Posted on 2004-08-02
5
516 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

632 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