Re: linked tables not working

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.

--

Ken Snell
<MS ACCESS MVP>



"Will Sellers" <willsellers@xxxxxxxxxxx> wrote in message
news:g8KdnUC5Va0cnKPYnZ2dnUVZ_oadnZ2d@xxxxxxxxxxxxxx

"Ken Snell (MVP)" <kthsneisllis9@xxxxxxxxxxxxxxxxxx> wrote in message
news:On5aNWs9GHA.3916@xxxxxxxxxxxxxxxxxxxxxxx
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


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.




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


Ken Snell
<MS ACCESS MVP>


"Jeff Boyce" <JeffBoyce_IF@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:uNR7bEq9GHA.3352@xxxxxxxxxxxxxxxxxxxxxxx
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
http://mvp.support.microsoft.com/

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

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


"Will Sellers" <willsellers@xxxxxxxxxxx> wrote in message
news:v_2dnXLjCZl7oKHYnZ2dnUVZ_rydnZ2d@xxxxxxxxxxxxxx
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)









.