Why do I have problems connecting to OLE server or activeX control?

Question

When i work with MS Access it says "problem occured while connecting to OLE server or activeX control. close it outside the access and perform the original operation"

what is causing this???? could you help me????

Answer

This question was answered on November 23, 2004. Much of the information contained herein may have changed since posting.

This message usually appears when you try to embed a Microsoft Word document in Microsoft Access This problem may occur if you have Norton AntiVirus 2000, 2001, 2002, 2003, or 2004 installed on your computer This problem may also occur if you have run Norton's LiveUpdate and have installed the Script Blocking update for Norton AntiVirus 2001 thru 2004

To resolve this problem, use on of the following methods:

Method 1

Turn off Norton AntiVirus Script Blocking (Note - Norton AntiVirus 2000 does not support the Script Blocking feature If you're using the 2000 skip to method 2)

1 Start Norton AntiVirus

2 Click Options

3 Click Norton AntiVirus if a menu appears when you click Options.

The Norton AntiVirus Options dialog box appears

4 Click Script Blocking

5 Click to clear the Enable Script Blocking (recommended) check box

6 Click OK

Note You can turn on Script Blocking again after you are finished using Access.

Method 2

Turn off the Norton AntiVirus Office plug-in for Microsoft Office

Note This method turns off the virus scanning plug-in that is installed during Norton AntiVirus installation This plug-in scans documents for macro virus infections in Office programs When this plug-in is turned off, Norton AntiVirus does not scan documents that are open However, the Norton AntiVirus Auto-Protect feature still provides on-going enhanced protection by scanning any file that you run, download, open, create, or delete For additional information about Norton AntiVirus, see your product documentation.

For Norton AntiVirus 2002, Norton AntiVirus 2003, and Norton AntiVirus 2004, follow these steps:

1 Start Norton AntiVirus.

Note If Norton AntiVirus is part of Norton SystemWorks (NSW) or Norton Internet Security (NIS), start NSW or NIS, and then click Norton AntiVirus

2 Click Options, and then click Miscellaneous

3 In the How to keep Microsoft Office documents protected section, click the Enable Office plug-in.

This clears the Enable Office plug-in

4 Click OK, and then quit Norton Antivirus

For Norton AntiVirus 2001, follow these steps:

1 Start Norton AntiVirus 2001.

Note If Norton AntiVirus is part of Norton SystemWorks (NSW) or Norton Internet Security (NIS), start NSW or NIS, and then click Norton AntiVirus

2 Click Options, and then click General

3 In the Microsoft Office 2000 plug-in section, click the Enable plug-in.

This clears the Enable plug-in

4 Click OK, and then quit Norton Antivirus

For Norton AntiVirus 2000, follow these steps:

1 Click Start, and then click Run

2 In the Open box, type one of the following commands, and then press ENTER

The command that you type depends on your operating system and the software that you are running Make sure to include the quotation marks when you type the commands.• For Windows 95 or Windows 98 with Norton AntiVirus installed, type the following command:"C:\Windows\System\Regsvr32" -U "C:\Program Files\Norton AntiVirus\OfficeAV.dll"

• For Windows 95 or Windows 98 with SystemWorks installed, type the following command:"C:\Windows\System\Regsvr32" -U "C:\Program Files\Norton SystemWorks\Norton AntiVirus\OfficeAV.dll"

• For Windows NT or Windows 2000 with Norton AntiVirus installed, type the following command:"C:\Winnt\System32\Regsvr32" -U "C:\Program Files\Navnt\OfficeAV.dll"

If the command is successful, you receive the following message:

DllUnregisterServer in C:\Program Files\Norton AntiVirus\OfficeAV.dll succeeded.

If the command is not successful, search your hard disk for the OfficeAV.dll file The path of the OfficeAV.dll file on your computer may be different from the path in the message When you locate the OfficeAV.dll file, remember the location of the OfficeAV.dll file, and then follow these steps again However, this time change the "C:\Program Files\Norton AntiVirus\OfficeAV.dll" part of the command in step 2 to the path of the OfficeAV.dll file on your computer.

Need Help with this Issue?

We help people with technology! It's what we do.
Schedule an Appointment with a location for help!

Author

Posted by Henry of Katharine Gibbs School - New York on November 23, 2004