linked tables not working

W

Will Sellers

I am trying to do a simple link table.
Access does not show the liked tables.
If I import I get the same result (can't see the tables)
 
J

Jeff Boyce

Will

When I need to link a table, I open an Access file to the database window,
click Files | Get External Data | Link ..., then set the type of table/data
and locate the source. If an Access db, I then select which table(s) and
click OK. This works for me, unless the tables I'm linking to are system
tables (or hidden) and I have those check boxes in options unchecked.

Is this the process you are using?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
K

Ken Snell \(MVP\)

Might be the issue noted in this MS Knowledge Base article:

BUG: List of currently linked tables may not appear in Linked Table Manager
Wizard in a database in Access 2003
http://support.microsoft.com/kb/835519/en-us


Most of us MVPs and others have been successful with fixing this problem
only by manually changing the registry key value (the article discusses
this); reregistering the accwiz.dll file hasn't worked for most of us.
 
W

Will Sellers

So by changing the registry key you were able to get the link function back?
I have been linking external files .txt, xls for quite some time .I guess
one of those $%#$#$@#$@ auto updates
from Billy's Boys broke what use to work.
 
W

Will Sellers

Ken Snell (MVP) said:
Might be the issue noted in this MS Knowledge Base article:

BUG: List of currently linked tables may not appear in Linked Table
Manager
Wizard in a database in Access 2003
http://support.microsoft.com/kb/835519/en-us
Click to expand...
I tried the regvr.32 option which yield a library error so I then tried
searching the registry.
I searched via the data value which displayed the data value as default.
Deafult {5B87B6F0-17C8-11D0-AD41-00A0C90DC8D9}
Am I suppose to change that value to the path/Accwiz.dll (including the
period)?

If the previous method does not resolve this problem, examine the following
registry value data to see if the value data is pointing to the correct
Accwiz.dll file in Access 2003.
HKCR\TypeLib\{5B87B6F0-17C8-11D0-AD41-00A0C90DC8D9}\8.0\0\win32\<(Default)>
where (Default) is the following registry key value:
C:\Program Files\Microsoft Office\OFFICE11\ACCWIZ.DLL.
 
K

Ken Snell \(MVP\)

Be very careful when editing the Registry!

You need to navigate to the "bottom" of the tree path shown below (watch for
line-wrapping -- it's all one line):

HKEY_CLASSES_ROOT\TypeLib\{5B87B6F0-17C8-11D0-AD41-00A0C90DC8D9}\8.0\0\win32

Expand HKEY_CLASSES_ROOT tree.
Navigate to TypeLib and expand it.
Navigate to {5B87B6F0-17C8-11D0-AD41-00A0C90DC8D9} and expand it.
Navigate to 8.0 and expand it.
Navigate to 0 and expand it.
Navigate to win32 and expand it.

At this key, you'll see (Default) on the right side of the RegEdit window.
The Data string needs to be the path to the accwiz.dll file. If it's not,
edit the Data to change the string to be the correct path.
 
Top