No of visitors who read this post: 425
Category: Database
Type: Question
Author: Kellen
No votes yet

Hello,

My database works very well on my hard disc. But whenever I try to run it on the server, I get the following error:

'ActiveX Component Can't Create Object'

Here's the code that activates the error:

Set appWord = GetObject(, "Word.Application")

Need some suggestions for this error. I am not able to make any updates there. Thanks a lot.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

#

Dear Kellen

U didn't give enough information about ur case, I think we need to know more about what database or server u r using. Anyway, the cause of this problem, according to Microsoft support page, may be one of the following:  the Data Access Objects (DAO) is not registered properly, one or more of the references r missing, invalid utility database reference, damaged wizard file or u don't have the required permissions for the required libraries. In the Microsoft support page of this error " ActiveX component can't create object", u can find a resolution to each cause mentioned above. Here is the link: http://support.microsoft.com/kb/319844

Hope this may help you.

Best of luck

# (Solution Accepted)

The error "ActiveX Component Can't Create Object" often appears when there are one or more references that are missing, or if the Data Access Objects is not registered, if there is a database reference that could not be validated or if you don't have permissions for the libraries.

You did not state more about the error you are receiving. But anyway to fix this, I think you need to use the GetObject that is fundamentally to get an open instance on the application. Just use the command for CreateObject. Here is the syntax:

Set appWord = CreateObject ("Word.Application")

Cathy Emrald