N/APosted on - 02/25/2012
I found my database works just fine on my hard drive but not on the server.
I receive the error:
'ActiveX Component Can't Create Object'
these are the line of code that triggers the error:
Set appWord = GetObject(, "Word.Application")
Any ideas for this?
I am owner of the server so unable to make any updates there.
Solutions for database error on server
The Syntax used here Set appWord = GetObject(, "Word.Application") seems to be the root cause of the error.
This is basically utilized to open the application instance.
This is not recommended here. If the instance is not opened and this syntax is used it can be problematic and can feasibly yield error. Under these circumstances create object can be efficiently used.
Hence the syntax should be as listed below.
Set appWord = CreateObject ("Word.Application")
Besides, ensure that you have administrative rights on the server.
Kinldy make sure that Microsoft office is installed on the server that you are currently using as most server are basically deprived of the software.