Problems with Norton AntiVirus 2006 and ODBC Connections

While I run Kubuntu as my primary OS on all my home machines, my work machine has Windows XP on it.  Recently our IT dept installed Norton AntiVirus 2006 on all our machines.  Some people had problems with this immediately, while others (like myself) had not noticed any problems.  Then today I tried to export some data out of Microsoft Access to a MySQL server via an ODBC connection; only the window to select which connection to use never came up.  One of my co-workers had this problem last week and it quickly escalated into something of a nightmare causing her to get stuck with the office’s loaner machine.  I did some googling and found a simpler solution to the problem:

  1. Double-click on Norton AntiVirus in the systray.
  2. Click on the Norton AntiVirus tab.
  3. Click on Settings.
  4. Click on Virus And Spyware Protection Options (under Additional Options)
  5. Click on Miscellaneous under Advanced Options.
  6. Uncheck Turn on scanning for Microsoft Office documents.
  7. Click Ok.
  8. Restart your computer.

And that’s it.  Simply disabling Norton’s Office plugin fixed the problem for me.

Related Posts