Linked Table Manager Blank

[Kelvin Wilson]

Seven years ago I made a little database to report on contact names
and addresses for a Church in Access 97, then used the database
splitter to make a back end and a front end. The database has since
been upgraded to Access 2000 then XP and now 2003.

In all previous upgrades the Linked Table Manager has worked perfectly
when the database has been moved from machine to machine as the
position of Secretary has changed. I have retained loose control of
the database for all these years and the structure has not changed.

With the last upgrade to Access 2003, the Linked Table Manager list of
tables is completely blank. Allen Browne suggested I check the
references, but they appear fine.

I finally imported all tables, queries, modules, forms and reports
into a new blank single database in Access 2003 then used the database
splitter thinking that would resolve the problem, but again the Linked
Table Manager list is empty.

Dev Ashish's fRefreshLinks function works just fine, and that's how
I'm getting around this problem, but I wonder if anyone else has come
across this and what the problem might be?

Kelvin Wilson

 

[Arvin Meyer]

I had the same problem, but it isn't database specific. I figured that the
problem occurs, at least in part, because I have both Access 2002 and 2003
versions on the same instance of the O/S (Windows XP). Access 2002 allows
use of the link table manager, but not viewing of any code. Access 2003
allows viewing the code, but not linking the tables. On separate machines,
actually on separate O/S, because they can be on the same machine it will
work fine.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Kelvin Wilson]

I had the same problem, but it isn't database specific. I figured that the
problem occurs, at least in part, because I have both Access 2002 and 2003
versions on the same instance of the O/S (Windows XP). Access 2002 allows
use of the link table manager, but not viewing of any code. Access 2003
allows viewing the code, but not linking the tables. On separate machines,
actually on separate O/S, because they can be on the same machine it will
work fine.

Wow, Marvin, don't you ever sleep?

Thanks for this. It sounds like you are right. Both machines doing
this are Windows XP with Access 2002 and 2003 installed.

 

[Arvin Meyer]

Wow, Marvin, don't you ever sleep?

The name is Arvin, with an A. No, I don't sleep very much. About 4 hours a
night is my limit. After that I wake up having been bored by sleeping too

Thanks for this. It sounds like you are right. Both machines doing
this are Windows XP with Access 2002 and 2003 installed.

This happens on ADPs as well. FWIW, I have not been able to find any KB
articles or anything on Google. This didn't come up during my beta testing
because I isolate the beta system. I guess I'll have to file a bug on it.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Joan Wild]

Re-register accwiz.dll (the one located in the same folder where Access 2003
is installed)

Regsvr32 "path\ACCWIZ.DLL"

 

[Arvin Meyer]

That did it.!
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Joan Wild]

I'm not positive, but you may have to keep doing that.

Switching between the two versions, may unregister it - can't test for
myself.

 

[Kelvin Wilson]

Not yet.

Thanks for you help, Joan, I use several different versions of Access
all the time, and the problem hasn't recurred.