Linked Tables Do Not Show Up In Window in 2003 version

R

Ron

I have data tables on the network in one Access database and the programms,
query etc in another. When I open the database in Access 2000 they appear.
When I open it in Access 2003, no linked tables appear. When I click "select
all" it starts asking me for table locations, but there are none appearing.
 
D

Dirk Goldgar

Ron said:
I have data tables on the network in one Access database and the
programms, query etc in another. When I open the database in Access
2000 they appear. When I open it in Access 2003, no linked tables
appear. When I click "select all" it starts asking me for table
locations, but there are none appearing.

Are you talking about linked tables not showing up in the database
window, or in the Linked Table manager? If it's the latter, see this
Microsoft KnowledgeBase article:

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

Ron

I ran the process and got the following response: "RegSvr32:
LoadLibrary(C:\Program") filed - The specified module could not be found.
Then I triend the second recommendation. I did a Registry search for where
the pointer was for the file Accwiz.dll.
I got the REG_SZ path correctly for some but pointed to my Access 2000 in
others.
 
D

Dirk Goldgar

Ron said:
I ran the process and got the following response: "RegSvr32:
LoadLibrary(C:\Program") filed - The specified module could not be
found. Then I triend the second recommendation. I did a Registry
search for where the pointer was for the file Accwiz.dll.
I got the REG_SZ path correctly for some but pointed to my Access
2000 in others.

The message you got when you ran regsvr32 suggests to me that it didn't
properly parse the path, and was cvonfused by the embedded space. Try
running regsvr32 again, but this time enclose the entire path to the DLL
in quotes. Like this (though the path on your machine may be
different):

regsvr32 "C:\Program Files\Microsoft Office\OFFICE11\ACCWIZ.DLL"

Note: the above command was entered all on one line. If the newsreader
has broken it into two lines, join them back together.
 
Top