Solutions for database error on server

Asked By kristan lai 30 points N/A Posted on - 02/25/2012

Hi guys,

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.

Thanks.

• Status: Open
• Question Views: 989
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Server Software

Answered By Perlas Draplin 5 points N/A #109973

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.

About Perlas Draplin

Questions
1

Answers
54

Best Answers
16

• Vote Up 0 Vote Down

• Posted on - 02/26/2012
• Question Category: Server Software