Solved

Linked table manager (Access 2003) does not show any tables

Posted on 2004-10-07
42
23,444 Views
Last Modified: 2013-12-03
I have multiple computers that have Access 2003 and the linked table manager (tools > database utilities > linked table manager) comes up empty even though the database has dozens of ODBC linked SQL tables.  The tables even open.  We have repaired then reinstalled Office 2003 and done all the updates via the Microsoft website, but still nothing in the linked table manager window.

See graphic:

http://www.command-systems.com/GeekBoy/LinkedTableManagerEmpty.jpg

I searched the EE and the MSKB, but found nothing other than repair the installation or reinstall.  There was one suggestion about registering Office11\ACCWIZ.DLL by dropping it on regsrv32.exe, which we did, and it was successfully registered, but still no linked tables.

We are stuck.

Thanks!
GeekBoySteveS
0
Comment
Question by:geekboysteves
  • 15
  • 5
  • 5
  • +6
42 Comments
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12249344
0
 
LVL 36

Expert Comment

by:SidFishes
ID: 12249360
try deleting an odbc linked table (just the link not the table!) and redo...see if that helps
0
 
LVL 6

Expert Comment

by:mcorrente
ID: 12249383
If all else fails, try exporting everything to a new database and linking the tables again.  May be corrupt database.
0
 
LVL 36

Expert Comment

by:SidFishes
ID: 12249399
you can unhide MSysObjects (tools options system objects) have a look for your links..are they there...

you could also try to copy the whole thing into a new mdb
0
 

Author Comment

by:geekboysteves
ID: 12249403
> try deleting an odbc linked table (just the link not the table!) and redo...see if that helps

I did that yesterday and it did not make any difference.  I was thinking maybe that one table might show up, but still empty.  Sorry, should have mentioned that in my question!  I am going to check out the link supplied by shanesuebsahakarn now.
0
 

Author Comment

by:geekboysteves
ID: 12249836
This link from shanesuebsahakarn...

http://support.microsoft.com/default.aspx?scid=kb;en-us;323658&Product=acc

...had to do with Oracle and Access 2000.  I even tried the registry hack suggested there, but it really didn't apply or make any difference.  I put it back the way it was.

As for the MSysObjects, the linked tables are in there and my database is not corrupt.  This problem is system-wide, that is, a computer with this problem shows an empty linked table manager in all databases, and we have a bunch.

Sorry to keep shooting down all these ideas!
0
 
LVL 50

Expert Comment

by:Steve Bink
ID: 12250259
Can you still access the linked tables?
0
 

Author Comment

by:geekboysteves
ID: 12250435
Yes, the tables come up fine and the application works.  Of course we copy databases around from one developer's computer to the next, and to laptops and then need to refresh the links.  We also have end-users complaining about this.

Here's something really odd: If you ignore the fact that the linked table manager window is empty and click "select all" then "OK", the progress meter shows "Refreshing linked tables..." and the little boxes march across and then it says "all linked tables successfully refreshed".  If you check the box that says "always prompt for a new location", and select all and proceed, it allows you to browse to your ODBC connection, but when you let it rip you get:

Method 'List' of object '1FieldListWnd' failed

Pasting that into Google returns exactly one hit*.  That is where I got the ACCWIZ.DLL red herring.

Also, on a computer with this problem, using Access 2000 the tables are all there in the linked table manager.

* Isn't there a prize for that?
0
 
LVL 50

Expert Comment

by:Steve Bink
ID: 12253736
This certainly sounds like a corruption issue, and the fact that you have already reinstalled Office at least once leads me to believe it is something in the DB as well.  Have you tried making a copy of the DB and programmatically removing all the linked tables?  If you can remove all the linked tables, then use the normal methods of relinking one, and have that one show up in the DB window, then we know the culprit was a corrupted internal table.

0
 

Author Comment

by:geekboysteves
ID: 12254018
I have many, many Access databases with linked tables on a network drive.  They all exhibit this behavior from a computer with the problem, but not from other comoputers that don't have the problem.  Same database; different behavior depending on the computer Access is running on.  Also, I have deleted the links and relinked and that doesn't make any difference.  Again, I don't think it can be in the database as the same database works fine from computers whose linked table manager works fine--or even from the screwed up computer if you use Access 2000 instead of Access 2003.
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12254744
Have you installed all of the Office 2003 service packs?
0
 
LVL 84
ID: 12255014
Perhaps mis-matched versions of MDAC? You can run the Component Checker from MS to determine the version of MDAC installed on a "good" machine vs a "bad" machine.

Component Checker:
http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en
0
 

Author Comment

by:geekboysteves
ID: 12258522
Service packs: About MS Access shows SP1 and I don't think there is another for 2003.  Also, I have been to Office Update and it says there are no updates for the bad computers.  Isn't that all I can do as far as SPs go?

MDAC: Does that apply on XP?  I thought that went away with Windows 2000 and beyond.  I'll run the checker, though, and report back.

Thanks for your perseverance!
0
 
LVL 84
ID: 12259244
Service packs - You certainly should update Access and Office, but those have nothing to do with MDAC - this is ENTIRELY separate and is not automatically updated.

MDAC: Yes, this applies to XP. MDAC is alive and well and is the root of many odd issues associated with Access, especially when dealing with linked tables to a SQL server. I really don't think this is your issue, however, but it's worth a look. Run the component checker - if nothing else, it'll eliminate at least one avenue of suspicion.
0
 

Author Comment

by:geekboysteves
ID: 12260399
I ran the MDAC component checker.  The machine that does NOT work instantly reports: The following product releases were matched: MDAC 2.8 RTM (It's a Windows Server 2003 box.  We also have the problem on two XP SP2 machines but I won't have access to them for a couple of days (on a trip).)

On two where the linked table manager works properly cc.exe says: The following product releases were matched: UNKNOWN

Drilling down to the ODBC driver for SQL Server (SQLSRV32.dll) I find this version on the BAD box: 2000.85.1025.0 and...
...this version on the GOOD box: 2000.85.1117.0

Different OSs, however.  How in the heck do you update this?  Should I attempt it?
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12260534
Sounds like that could be the version from the post 2.8 hotfix. Try downloading it from office.microsoft.com, and see if that fixes it (search for MDAC 2.8).
0
 

Author Comment

by:geekboysteves
ID: 12260756
The MDAC 2.8 download I found* supports all OSs except the one I am using, in this case Windows Server 2003.

* http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en

Can I update just the SQL Server ODBC Driver component somehow?  Is all this really likely to help?
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12261038
Look here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=39472ee8-c14a-47b4-bfcc-87988e062d91&DisplayLang=en

MDAC will need to be updated on your workstations rather than your server.
0
 

Author Comment

by:geekboysteves
ID: 12261611
My Windows Server 2003 machine is an Application Server.  Access 2003 is the main application it serves up to remote users.  I'm going to install the security patch above on it.  I tried installing it on one of my good XP computers and it would not.  Complained it could not determine the current version of MDAC--just as cc.exe declared the version UNKNOWN.
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:geekboysteves
ID: 12297827
I have tried all the suggestions posed here and I appreciate everyone's time.  Nothing helped, so I am not sure this entire thread needs to stay in the system.  I am going to ask the EE Overlords to remove it.  I will probably call Microsoft support to see what to do.
Thanks again!
Steve
0
 
LVL 36

Expert Comment

by:SidFishes
ID: 12299480
might it not be worthwhile to paq and refund?  

if someone else runs across this problem, at least knowing that the only apparent answer is a call to MS...and if MS has an answer...the author could post here for...

just a thought...
0
 

Author Comment

by:geekboysteves
ID: 12299789
I am on the phone with Arvid Saxena (Microsoft technical support).  Have been for one hour.  He is stumped but still working with me.  I'll keep you posted.
Steve
0
 

Author Comment

by:geekboysteves
ID: 12301932
After three hours on the phone, we are pretty sure the problem is with computers with multiple versions of Access, usually.  Not only that, but the DLL "accwiz.dll" in particular, is at the heart of it.

I registered it using:
regsvr32.exe "C:\Program Files\Microsoft Office\Office11\accwiz.dll"
...on one of my computers with this problem and it fixed it.  It did not fix it on my main computer--a Windows Server 2003 running as an (Access 2003) Application Server.  It would not even let regsvr32 register the DLL.  MS sent me a new DLL and still no go on registering it.  Then MS sent me "regtlib.exe", which was able to register accwiz.dll, so that was cool!  Too bad the linked table manager is still empty.  :(

As for accwiz.dll, search the MSKB for 835519 for complete details.  My case is still open with Microsoft technical support, but I am not holding my breath.

As for removing this question from the EE, I think the new information regarding accwiz.dll could be a help to some people with this problem.  It fixed one out of three of my computers.  All the rest of our systems were OK anyway, so we know how to install Access.

Steve
0
 
LVL 50

Expert Comment

by:Steve Bink
ID: 12302341
I'm all for PAQ/Refund.  

geekboysteves: please keep us up-to-date on anything returning from MS on this issue.  I'd be quite interested in seeing a final resolution to this.
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12309130
I agree, PAQ/refund is good.
0
 

Accepted Solution

by:
geekboysteves earned 0 total points
ID: 12318624
This looks like the final word from Microsoft on this issue:

"It is my pleasure working with you on your Microsoft Access issue. I am able to reproduce the same scenario on few of the machines here. It is causing only on the machines where you have installed two different versions of Access.

Same Issue where only one Access Version is installed
            1. Try registering the ACCZIW.DLL
            2. If it doesn't resolve the issue, install the upgrade (Access Service Pack) it will replace the old file with newer version.

Same Issue where more than one Access Version is installed
            1. Try registering the ACCZIW.DLL
            2. If it doesn't resolve the issue, install the upgrade (Access Service Pack) it will replace the old file with newer version.
            3. If it doesn't resolve the issue, the problem is due to multiple versions. (We don't recommend two versions on same machine)

We might not face the problem when we install Access 2003 first and then earlier version (or vice versa). I am going to do more research on this and will update you.

Kindly update me about the progress at your end and do let me know if you have any other input for me, which can help us to resolve the issue.

Thank you,

Arvind S. (last name abbreviated by GeekBoySteveS)
Access Support Engineer
Microsoft Global Support Center"

So MS cops out saying they don't recommend multiple versions on one machine, this after Arvind boasted to me that he has four versions on his computer.

I would like to add that on a machine with only Access 2003, the accwiz.dll fix worked.  On machines with (97 or 2000) and 2003, the accwiz.dll fix did not work, however, on my sick, multiple version machine, Access 2000's linked table manager workes fine as does a VB function I wrote to allow the user to select the ODBC connection, which then refreshes the links.  This code is available to anyone curious about it, just ask and I'll post it.
GeekBoySteveS
0
 

Expert Comment

by:HarrySanders5
ID: 12372318
I am running Access 2003 sp1 under Windows XP sp2 and am have exactly the same problem with the linked table manager. I have found no solution other than removing the older versions of Access.

HarrySanders5
0
 

Author Comment

by:geekboysteves
ID: 12372757
HarrySanders5,
Are you running _Office_ 97/2000/2002 Pro and Access 2003 by any chance?  I mean, do you have Access 2003 as a stand-alone product possibly, installed after a full Office 2000 Pro, for example?  That is the configuration that I can't fix.  I need 2000 and 2003 on the same machine.  The linked table manager would be nice, but I have work-arounds.  Of course my installation is complcated by the fact that my computer is a Windows Server 2003 in Application Server mode...
GeekBoySteves
0
 

Expert Comment

by:HarrySanders5
ID: 12373140
GeekBoySteves
When I originally had the problem I had Office Developer 2003 and Office 2002 runtime installed at the same time. I removed the 2002 runtime and the problem went away. Later I reinstalled 2002 full edition (developer) along with 2000 developer and the problem returned. The linked table manager seems to work fine with the older versions (2002 and 2000).

I no longer use Access 97, so it is unlikely I will need to install it.

HarrySanders5
0
 

Expert Comment

by:Airgazm
ID: 12418750
Hi guys, I was just poking around for a bit trying to solve the same issue.  

My Access 2003 wouldn't even bring up a window for the Table Manager after I installed SP1.  I came across this post and registered  regsvr32.exe "C:\Program Files\Microsoft Office\Office11\accwiz.dll"

This got the Table Manager window to pop up but still no tables.

I then read you talking about different versions, and sure enough I have the 2002 Runtime installed.  
I uninstalled it and now I have the Table Manager with the tables in it.

-Air
0
 

Author Comment

by:geekboysteves
ID: 12421719
MS called me at least three times before closing this issue.  Arvind (MS engineer) duplicated the problem on multiple computers including a Windows 2003 Server.  He found that if multiple versions of Access are installed in version order but to *different folders* (not all pointed to Program Files\Microsoft Office) and the accwiz.dll is registered, then the linked table manager works properly in 2003.

I have not been able to put this to the test on my production application server, but I take his word for it.  MS really bent over backwards on this issue, and they "refunded" my support call--so I still have a "free one" in the bank.

Steve
0
 

Expert Comment

by:Airgazm
ID: 12425756
What about all our lost time trying to solve the issue, Microsoft looks all good that they helped, but their bug caused us all grief/time/money and they should be paying us to solve it for them. In return they outsourced the support to India.  

Please don't act like they did you a favor, you just solved a bug for them and they are letting you go without paying the tax, oh gee, thank you Microsoft.

0
 
LVL 36

Expert Comment

by:SidFishes
ID: 12426600
" all pointed to Program Files\Microsoft Office"

this actually isn't a bug...you install any program over older versions you are going to get weird behaviour...if the thing works at all...I've installed A97, A2000 and A2002RT "in different folders" and not had any problems...and completely hosed one install by forgetting to change the default install folder...but that's MY problem...not MS's

i've seen all sorts of dll probs caused by multiple version installations... not just in access altho the wizards seem especially prone
to problems...




0
 

Expert Comment

by:Airgazm
ID: 12426684
I would at least hope the Microsoft would program some logic into the install to not allow this to happen, but from a marketing approach I guess you could make more $$ if the program didn't do any checks and people had to call in for support.

0
 

Expert Comment

by:HarrySanders5
ID: 12434635
By default, Access installs itself in different folders (Office10, Office11, etc). Is Microsoft saying that this is not adequate and that we need to install completely independent paths for different Access versions?

0
 

Author Comment

by:geekboysteves
ID: 12434714
It is my understanding that the problem is exacerbated by installations of multiple versions with "Program Files\Microsoft Office\" in common.  The line of demarcation should be immediately after "Program Files".

As in:

\Program Files\MSO97
\Program Files\MSO2K
\Program Files\MSOXP
\Program Files\MSO2003

Steve
0
 
LVL 36

Expert Comment

by:SidFishes
ID: 12434928
that's exactly my experience GBS...and with that setup...been no problems...except for the A97 No License bug (which is a true bug) which has an easy fix (the Haettenschweiler Font switcheroo)
0
 

Expert Comment

by:lwarneminde
ID: 12781960
I got this problem even though my installs are in different drives!
Office 97 Pro - C:\Program Files\Microsoft Office\Office
Office 2K3 Pro - F:\Program Files\Office2K\OFFICE11

Removing Access 97 fixed up the linked table manager (I'd already tried registering accwiz.dll to no avail).
However, I also have an install of Outlook 2002 in C:\Program Files\Office2K\Office10. Can't see why that would have an impact but it sounds like the only difference from MS's scenario.
0
 
LVL 50

Expert Comment

by:Steve Bink
ID: 12784132
It probably does not matter if they are installed to different places since some files go into the \Program Files\Common or the system directories.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now