Linked Table Manager Problem

[Rob Parker]

I am designing an application which has split front-end and back-end
database files, implemented with user-level security, in Access 2003. The
Linked Table Manager no longer shows any linked tables to refresh - the list
box is empty. This happened following an error while I was checking
behaviour for various Groups (sorry, I can't remember the exact details - it
was two days ago); previously, the Linked Table Manager worked fine. I have
compacted/repaired my database, decompiled and recompiled, with no effect -
and I don't have any other signs of corruption in the database. I
subsequently found that the LTM has stopped working not only for this
application, but for all databases which I open with A2003.

I searched this newsgroup and found several posts on this topic; the usual
cure is to re-register the accwiz.dll file. Did this, with no success.
Manually checked the registry entry as per KB 835519, and it seems OK
(although the entry for the A2003 dll is in key ...\8.1\..., rather than
....\8.0\... - I assume this is because I previously had A2000 installed,
because the entry in 8.0 is correct for the A2000 dll).

I have repaired my Office 2003 installation - no change; the LTM still
refuses to work.

Other info: my system has A97, A2000 and A2003 all installed, and all needed
to support legacy applications. A2003 was the last installed version. As I
said above, the LTM in A2003 was working (with all Access versions
installed), but is now "broken". A97 did not have an in-built LTM; but the
add-in works fine. The LTM in A2000 still works fine.

I have some code in my app which checks to ensure that the linked database
is present, and prompts for a new file to refresh links if it is not found;
that works OK, even though the LTM is not working.

Any suggestions as to what has failed, and why, and (most importantly) how
to fix it, will be gratefully received. And tried, when I get back to work
after the extended long weekend here in Oz for our national day!

TIA,

Rob

 

[Joan Wild]

Are you certain you are registering the correct accwiz.dll file? You need
to register the one that's located in the folder where Access 2003 is
installed.

 

[Rob Parker]

Yes, I'm certain I registered the correct dll (at least twice - just to make
certain!). The registry entry is for the dll in the Access 2003 folder, but
the LTM refuses to show any linked tables.

Rob

 

[Pieter Wijnen]

There's a possibility that there's a registry entry for AccWiz.dll that
points to %windir%\system32\AccWiz.dll (Access 97)
Update to correct path (known issue - I don't remember where though)

HTH

Pieter

 

[Joan Wild]

It's always worked in the past for me. You say that it was working and then
stopped after you got some error.

Since the repair didn't work, I'd try uninstalling 2003 and reinstalling it.

Also run offcln.exe after uninstalling and before you reinstall. You'll
find it on the Office 2003 CD.

 

[Rob Parker]

Thanks for the reply, Pieter.

The registry entry points to the correct dll with a full path/filename, not
a parameterised version such as you suggest. Doesn't seem that that's the
problem in this case.

Rob

 

[Rob Parker]

Thanks for the reply Joan.

I've removed and re-installed Office 2003 (including checking with
offcln.exe that there's nothing that's been missed), and the problem is
still there. And yes, it was working (with three versions of Access
installed on the system) and then stopped working after an error.

At this stage, I'll live without it, because I can rename/move my back-end
to force a re-link via the code in my application. Beyond that, ??? Maybe
I'll just remove all previous versions of Access, and see if that fixes it -
and then think about how to re-install them so that I can still work with
the old applications.

Rob

 

[OzMaz]

Hi Rob,

I have the same problem: no tables listed in the Linked Table Manager. After reading this thread an others I decided to 'become brave'. I read on one thread that having multiple versions of Access installed can cause this problem.

A quick look revealed that I had Office 10 and Office 11 components installed. What I did was go to the C:\Program Files\Office 10 folder and renamed ACCWIZ.dll to ACCWIZ_Old.dll and voila, the table names now appear in Office 11. I may have problems in previous versions, but this change gets me on my way.

Hope this is of some assistance.

OzMaz