Linked table manager works for A2003, not A2K, A97

[Bruce Dodds]

1) I recently installed Access 2003 on a system that already had Access
2000 & Access 97 installed.

2) I noticed that the linked table manager displayed a blank list.

3) After doing some research, I registered the new ACCWIZ.DLL as
instructed in Microsoft KB article 835519.

4) The A2003 linked table manager still displayed a blank list.

5) I renamed the A2K and A97 ACCWIZ.DLL files.

6) The linked table manager now works in Access 2003, but doesn't work
in Access 97 & Access 2000. I restored the name of the A2K copy of
ACCWIZ.DLL to "ACCWIZ.DLL", but that didn't fix it.

Does someone know of a way I can configure the system so that all three
versions of ACCWIZ.DLL are working with their respective versions of
Access? I would really rather not uninstall and reinstall all those
copies of Oddice, with their associated patches.

Thanks.

 

[Guest]

Hi Bruce. I had the same problem and your question actually fixed it. Here is
what I did.
1...I registered A2003 accwiz.dll and it worked, but A2000 didn't.
2...I then registered A2000 accwiz.dll and A2000 worked, but A2003 didn't.
3...I then re-registered A2003accwiz.dll, but A2003 still didn't work, but
A2000 still did work.
4...I then renamed accwiz.dll in A2000 and, believe it or not, they both
worked. I can't explain why.

I know it's confusing, but those are the exact steps I took.