A03: Can't Link ODBC Tables

#1 March 11th, 2008, 02:05 AM

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 my 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

#2 March 11th, 2008, 02:15 AM

Quite likely, this is your antiviruses at work. Deactivate any protection
related to Office, VBScript or ActiveScript and you should be OK. Later,
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" <nospam@nospam.netwrote in message
news:BElBj.15650$Ej5.6357@newssvr29.news.prodigy.n et...

Quote:

>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 my 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
>

#3 March 11th, 2008, 05:05 AM

The only security I have is my Norton Internet Security, which includes
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" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:ukVmDyxgIHA.484@TK2MSFTNGP06.phx.gbl...

Quote:

Quite likely, this is your antiviruses at work. Deactivate any protection
related to Office, VBScript or ActiveScript and you should be OK. Later,
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" <nospam@nospam.netwrote in message
news:BElBj.15650$Ej5.6357@newssvr29.news.prodigy.n et...

Quote:

>>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 my 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
>>

>
>

#4 March 11th, 2008, 09:45 AM

"Neil" <nospam@nospam.netwrote in message
news:BElBj.15650$Ej5.6357@newssvr29.news.prodigy.n et...

Quote:

>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 my 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?
>

Hi Neil,

If this were AccessXP, I might try checking the following
(not sure about Access 2003):

Close all Access programs.

1) try to find these 3 files on hard drive:

Acwzmain.mde
Acwztool.mde
Acwzlib.mde

{probably in C:\Program Files\Microsoft Office\Office10\ if Access XP}

Do they exist?

2) If so, then start 2 Window Searches

in one, search for Regsvr32.exe
in second, search for accwiz.dll

Drag-and-drop accwiz.dll onto Regsvr32.exe

You should get a message that reg successful.

Does it work properly now?

If not, you might try unregistering the dll,
then reregister.

Like I said before, I am unsure about Access 2003.

good luck,

gary

#5 March 11th, 2008, 12:15 PM

Hi,

Neil wrote:

Quote:

I think you're confusing 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.

Take a look at this thread, and you can read that it's not enough to disable
NAV:

http://groups.google.com/group/comp....fa0a14b03dcaf3

Regards
Jens

#6 March 12th, 2008, 02:45 AM

Well, that resolved it. Thanks so much!

Strange because:

a) didn't have this problem on my other computer with the same configuration
(is an older computer, so I must have disabled that option years ago)

b) didn't have this problem with Access 2000, even with that option turned
on.

Anyway, all is good now. Thanks again!

Neil

"Jens Schilling" <jensschillingBitteLoeschen@fissership.dewrote in message
news:fr5sii$1mg$00$1@news.t-online.com...

Quote:

Hi,
>
Neil wrote:

Quote:

>I think you're confusing 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.

>
Take a look at this thread, and you can read that it's not enough to
disable NAV:
>
http://groups.google.com/group/comp....fa0a14b03dcaf3
>
Regards
Jens
>
>

#7 March 12th, 2008, 06:45 AM

Hi,

Neil wrote:

Quote:

b) didn't have this problem with Access 2000, even with that option
turned on.

It seems that only A03 shows this behaviour - I didn't noticed it for
another version.

Regards
Jens

#8 March 12th, 2008, 08:05 AM

It seems that only A03 shows this behaviour - I didn't noticed it for

Quote:

another version.

*shaking fist at Microsoft*

#9 June 27th, 2008, 07:22 PM

On Mar 11, 10:23*am, "Sylvain Lafontaine" <sylvain aei ca (fill the
blanks, no spam please)wrote:

Quote:

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 same
problem as you have found that the cause was their antivirus and in most
cases, it was NAV who was involved. *I think that I remember some peoples
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 into
something else than an antivirus.
>
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
>
"Neil" <nos...@nospam.netwrote in message
>
news:GfuBj.13759$5K1.11502@newssvr12.news.prodigy. net...>I think you're confusing Norton Internet Security with Norton Firewall.

Quote:

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.

>

Quote:

However, to make the point, I explicitly disabled the Antivirus module.
Results are the same. So I'm sure that's not it.

>

Quote:

Thanks, though.

>

Quote:

Neil

>

Quote:

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in messagenews:ejMU8XzgIHA.4536@TK2MSFTNGP06.phx.gbl. ..

Quote:

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. *More info at:

>

Quote:

>http://support.microsoft.com/kb/329820/en-us

>

Quote:

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 Windows
Firewall). (However, the firewall can give trouble later when accessing
the data through a linked table.)

>

Quote:

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

>

Quote:

"Neil" <nos...@nospam.netwrote in message
>news:9ioBj.25637$J41.10175@newssvr14.news.prodigy .net...
>The only security I have is my Norton Internet Security, which includes
>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.

>

Quote:

>"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
>wrote in messagenews:ukVmDyxgIHA.484@TK2MSFTNGP06.phx.gbl.. .
>>Quite likely, this is your antiviruses at work. *Deactivate any
>>protection related to Office, VBScript or ActiveScript and you should
>>be OK. *Later, when you'll have finished etablishing your linked
>>tables, you can reenable this protection.

>

Quote:

>>--
>>Sylvain Lafontaine, ing.
>>MVP - Technologies Virtual-PC
>>E-mail: sylvain aei ca (fill the blanks, no spam please)

>

Quote:

>>"Neil" <nos...@nospam.netwrote in message
>>>news:BElBj.15650$Ej5.6357@newssvr29.news.prodig y.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.

>

Quote:

>>>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 my
>>>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.

>

Quote:

>>>I applied the SP3 patch last night, but the results are the same.

>

Quote:

>>>Any ideas about what I can try, or perhaps a file I can copy from my
>>>other PC, in which Link Tables works?

>

Quote:

>>>Thanks!

>

Quote:

>>>Neil