Cannot link to SQL tables using ODBC Link table in Access 2003

Cannot link to SQL tables using ODBC Link table in Access 2003

• farshid farzad

  I've lost the ability to "link table" for excel or txt files. Any suggestions I have Access 2003 & Norton AV. I've tried turning off Norton AV and clearing the "Turn on scanning for Microsoft Office documents", neither seems to help

  
  

• Kenneth Norway

  Thanks
  

• Mahmood Dhalla

  Here is the solution, from a member of UK AUG.

  Alan, you’re a genius; the cure works perfectly.

  Catherine, thank you too; I had noticed that Access especially was slow to open, but had no idea why.

  Andy Couch, this may come in hand for your next SQL Server course as you may have a Norton victim among your trainees.

  I’ll let my Norton 5-user subscription run out and them I’m in the market for something else - anything but Norton.

  Timothy Coe.

  ----------------------

  That option scans all Office documents before opening it, but if you have autoprotect on, there shouldn't be any viruses on them in the first place...Regards, Catherine.

  ----------------------

  Timothy,

  Downgraded is the correct word! It is awfully slow and my Office documents take ages to open now. I downgraded from Norton Internet Security 2005, which ran reasonably well, to 2006.

  Thank you for bringing this up. Now you have, it reminds me that I've posted before on problems with ODBC and NIS2006. I found that if I untick the "Turn Office Plug-in on" box on Miscellaneous on the Antivirus section of NIS2006, my ODBC options reappear and my Office programs, e.g. Word, open a bit quicker. I'm not sure off hand what I may be letting myself in for by turning this thing off though. NIS2006 Yuck. Alan

  
  

• robroll

  Great Job Alan/Tim!  You are fabulous - the fix works.  add a system re-start and life is good again!

  The fix:

  From Nortn Antivirus Home screen:

  Select Security Basics, Auto-Protect, and Configure Auto-Protect

  Under "Other", select Miscellaneous

  Under "How to keep Microsoft Office Documents Protected"  which should be renamed to "How to mysteriously destroy database development productivity", uncheck this evil box

  Restart and enjoy the functionality you paid for...

   

  Thanks again folks!

  Next stop:  complain to Symantec!

  
  
  

• uzalish

  Same Problem with NAV 2007,

  1) Bring up Norton Protection Center and Click on Antivirus tab.

  2) Click on Settings

  3) Basic Security

  - Click on Auto-protect

  - Click on Configure

  - On Left hand side at the bottom, click on MISCELLANEOUS

  - At Bottom of Right handside(options for miscellaneous)

  Uncheck "How to keep Microsoft Office Documents ProtectedUnder "

  - Click OK and close Norton Protection Center

  4) Reopen Access DB and you should be good to go!!

  Enjoy

  
  

• Dislay Name

  Thanks everyone, I had the same problem. The Norton Protection center needed:

  Norton Antivirus; Settings; Additional Options- Virus and Spyware Options;Miscellaneous; Turn on Scanning for Microsoft Office Documents

  When this is unchecked I can get ODBC links again.

  Mike

  
  
  

• MusicMan756

  Yes, I have the same problem and also installed Norton Anti-Virus 2006 recently. My OS is Windows XP Pro SP2. On another PC, where the only difference is that it has Access 2002, the problem does not occur and the dialog box comes up normally. I have floated this question on the UK AUG list processor and the first reply is that there is a Microsoft KB article on it, but my inter locutor does not know its number! Have you askled Norton
  
• Cannot link to SQL tables using ODBC Link table in Access 2003