Re: Can"t Link ODBC Tables

On Mar 11, 10:23=A0am, "Sylvain Lafontaine" blanks, no spam please)> wrote:
> Well, the last version of Norton that I've bought was the 2003; so I might=

> be a little confused with all these name changes that Norton and Symantec
> have brought to their list of products.
>
> However, as far as I know, all people who have been confronted with the sa=
me
> problem as you have found that the cause was their antivirus and in most
> cases, it was NAV who was involved. =A0I think that I remember some people=
s
> having problems with other antiviruses but I'm not sure. I don't remember
> anyone who had the same problem as you but with a cause that was rooted in=
to
> something else than an antivirus.
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
> "Neil" wrote in message
>
> news:GfuBj.13759$5K1.11502@newssvr12.news.prodigy.net...>I think you're co=
nfusing Norton Internet Security with Norton Firewall.
> >Norton Internet Security is not simply a firewall; it's an integration of=

> >Norton Firewall, Norton Antivirus, Norton Antispam, etc., into one module=
..
> >Disabling Norton Internet Security disables Norton Antivirus.
>
> > However, to make the point, I explicitly disabled the Antivirus module.
> > Results are the same. So I'm sure that's not it.
>
> > Thanks, though.
>
> > Neil
>
> > "Sylvain Lafontaine"
> > wrote in messagenews:ejMU8XzgIHA.4536@TK2MSFTNGP06.phx.gbl...
> >> If you have NAV 2006, deactivate the Office Plug-in that you will find
> >> under the Miscellaneous tab; if you have NAV 2007, deactivate the
> >> Scanning for Microsoft Office Documents. =A0More info at:
>
> >>http://support.microsoft.com/kb/329820/en-us
>
> >> If you don't find the right item, simply deactivate (temporarily) the
> >> whole anti-viruse package. The Norton Internet Security is simply a
> >> firewall and has nothing to do with this problem (and neither the Windo=
ws
> >> Firewall). (However, the firewall can give trouble later when accessing=

> >> the data through a linked table.)
>
> >> --
> >> Sylvain Lafontaine, ing.
> >> MVP - Technologies Virtual-PC
> >> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
> >> "Neil" wrote in message
> >>news:9ioBj.25637$J41.10175@newssvr14.news.prodigy.net...
> >>> The only security I have is my Norton Internet Security, which include=
s
> >>> Norton Antivirus. (This, by the way, is the same product I have on my
> >>> other computer, the one with no problems in this regard.) I disabled
> >>> Norton Internet Security, but the problem remained. I also checked
> >>> Windows Firewall, and it is turned off.
>
> >>> "Sylvain Lafontaine" >
> >>> wrote in messagenews:ukVmDyxgIHA.484@TK2MSFTNGP06.phx.gbl...
> >>>> Quite likely, this is your antiviruses at work. =A0Deactivate any
> >>>> protection related to Office, VBScript or ActiveScript and you should=

> >>>> be OK. =A0Later, when you'll have finished etablishing your linked
> >>>> tables, you can reenable this protection.
>
> >>>> --
> >>>> Sylvain Lafontaine, ing.
> >>>> MVP - Technologies Virtual-PC
> >>>> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
> >>>> "Neil" wrote in message
> >>>>news:BElBj.15650$Ej5.6357@newssvr29.news.prodigy.net...
> >>>>>I just started using Access 2003, and I can't link a SQL Server table=
..
> >>>>>I right-click on the database window; select Link Tables; and select
> >>>>>ODBC Databases from the Files of Type dropdown. As soon as I select
> >>>>>ODBC Databases from the Files of Type dropdown, the entire dialog box=

> >>>>>disappears. No error message. Just disappears, and I'm back at the
> >>>>>database window.
>
> >>>>> I have tried this with other databases, including a brand new blank
> >>>>> one, and the results are the same. So it's definitely something in m=
y
> >>>>> system, not the database. I also tried it on another computer I have=

> >>>>> running Access 2003, and it works fine. But on this computer, it won=
't
> >>>>> link ODBC.
>
> >>>>> I applied the SP3 patch last night, but the results are the same.
>
> >>>>> Any ideas about what I can try, or perhaps a file I can copy from my=

> >>>>> other PC, in which Link Tables works?
>
> >>>>> Thanks!
>
> >>>>> Neil

For details on disabling the Norton Office Plug-in on various Norton
installs, see http://support.microsoft.com/kb/329820.