Unable to link to ODBC using Access 2003

Answer

This either means that your ODBC server is not running.

or

The Norton AntiVirus plug-in for Microsoft Office scans documents for macro virus infections in Office products. This plug-in may cause Access 2003 to be unable to open ODBC data sources.

Method 1: Run Live Update

Obtain the latest version of the Norton AntiVirus Office plug-in that is available through the Live Update option site in your Norton AntiVirus software.

Note: An update to the Norton AntiVirus Office plug-in may not be available in all languages.

Method 2: Disable Norton AntiVirus Office plug-in

Use this method only if you cannot update your Norton AntiVirus software through the Live Update Web site.

Important These steps may increase your security risk. These steps may also make the computer or the network more vulnerable to attack by malicious users or by malicious software such as viruses. We recommend the process that this article describes to enable programs to operate as they are designed to or to implement specific program capabilities.

To disable the Norton AntiVirus Office plug-in, use one of the following methods, depending on the version of Norton AntiVirus that is installed on your computer.

Note: Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.

Norton AntiVirus 2007 or Norton Internet Security 2007 is installed

Disable the Turn on scanning for Microsoft Office Documents option. To do this, follow these steps. Warning: This workaround may make a computer or a network more vulnerable to attack by malicious users or by malicious software such as viruses. We do not recommend this workaround but are providing this information so that you can implement this workaround at your own discretion. Use this workaround at your own risk.

1.  On the taskbar, right-click the Norton icon, and then click Norton Protection Center.
2.  Depending on which version of Norton you are using, click Norton Antivirus or Norton Internet Security.
3.  Click Settings.
4.  Under Additional Options, click Virus and Spyware Protection Options.
5.  Click Miscellaneous.
6.  Under How to keep Microsoft Office documents protected, click to clear the Turn on scanning for Microsoft Office Documents check box.

Norton AntiVirus 2006 is installed

Disable the Norton AntiVirus Office plug-in. To do this, follow these steps. Warning This workaround may make a computer or a network more vulnerable to attack by malicious users or by malicious software such as viruses. We do not recommend this workaround but are providing this information so that you can implement this workaround at your own discretion. Use this workaround at your own risk.

1. On the taskbar, right-click the Norton icon, and then click Norton AntiVirus Options.
2. Click Miscellaneous
3. Click to clear the Turn Office Plug-in on check box

Norton AntiVirus 2004, Norton SystemWorks 2004, Norton AntiVirus 2003, Norton SystemWorks 2003, Norton AntiVirus 2002 or Norton SystemWorks 2002 is installed

Disable the Norton AntiVirus Office plug-in. To do this, follow these steps. Norton AntiVirus 2002 is used as an example. Warning This workaround may make a computer or a network more vulnerable to attack by malicious users or by malicious software such as viruses. We do not recommend this workaround but are providing this information so that you can implement this workaround at your own discretion. Use this workaround at your own risk.

1. Start Norton AntiVirus. To do this, click Start, point to All Programs, point to Norton AntiVirus, and then click Norton AntiVirus 2002. Note If you installed Norton   AntiVirus as part of the Norton SystemWorks 2002 program, click Start, point to All Programs, point to Norton SystemWorks, point to Norton AntiVirus, and then click Norton AntiVirus 2002.
2. Click Options. Note In Norton SystemWorks 2002, click Options, and then click Norton Antivirus
3. Under Other, click Miscellaneous.
4. Under How to keep Microsoft Office documents protected, click to clear the Enable Office Plug-in check box, and then click OK.
5. Restart the computer.

Norton AntiVirus 2001 or Norton SystemWorks 2001 is installed

Disable the Norton AntiVirus Office plug-in. To do this, follow these steps: Warning This workaround may make a computer or a network more vulnerable to attack by malicious users or by malicious software such as viruses. We do not recommend this workaround but are providing this information so that you can implement this workaround at your own discretion. Use this workaround at your own risk.

1. Start Norton AntiVirus. To do this, click Start, point to All Programs, point to Norton AntiVirus, and then click Norton AntiVirus 2001.
Note If you installed Norton AntiVirus as part of the Norton SystemWorks 2002 program, click Start, point to All Programs, point to Norton SystemWorks, point to Norton AntiVirus, and then click Norton AntiVirus 2002.
2. Click Options, and then click General.
3. Under How to keep Microsoft Office documents protected, click to clear the Enable Office Plug-in check box, and then click OK.
4. Restart the computer.

Norton AntiVirus 2000, Norton SystemWorks 2000, or Norton Internet Security is installed

Unregister the Norton AntiVirus OfficeAV.dll file. To do this, follow these steps: Warning This workaround may make a computer or a network more vulnerable to attack by malicious users or by malicious software such as viruses. We do not recommend this workaround but are providing this information so that you can implement this workaround at your own discretion. Use this workaround at your own risk.

1. Exit all programs.
2. Click Start, and then click Run.
3. Depending on how Norton AntiVirus 2000 is installed, type one of the following commands:
* If the Norton AntiVirus program is installed as a stand-alone product, type the following command, and then press ENTER:
regsvr32 /u “c:\program files\norton antivirus\officeav.dll”
c is a placeholder for the drive where Norton AntiVirus is installed.
If the command is successful, you receive the following message:
DllUnregisterServer in C:\Program Files\Norton AntiVirus\OfficeAV.dll succeeded.
* If the Norton AntiVirus program is installed as part of SystemWorks, type the following command, and then press ENTER:
regsvr32 /u “c:\program files\norton systemworks\norton antivirus\officeav.dll”
4. Click OK.
5. Restart the computer.