Linked Table Manager uninstalled!?

[Zen]

Hello, we made some changes to the front end of our database so I went to
two computers to replace the old front end with the new one.

I did not make ANY changes to any of these two computers. However now when I
try to run my front end it failes to load. If I try to open the file using
Shift Enter

and go to
Tools>Utilities>Linked Table Manager
it is grayed out!!

Seriously before I tried using my new front end I was using the old front
end just fine all day on both of these computers.

So then it said this feature is not installed would you like to install, of
course I said yes. But I still can't load my front end due to the same
problem.

So I insert my install disk and prompted to do a repair install and I still
have the same problem.
this is pretty frustrating

 

[Zen]

I forgot to mention, I'm using office 2002

 

[Zen]

I just uninstalled completely... rebooted and tried reinstalling.

This is outrageous. Wont be back until Tuesday unfortunately. Any help
appreciated though.

 

[Douglas J. Steele]

No idea what might have caused the problems, but you can delete the
existing linked tables and create new ones, or you can add your own code to
relink the tables. See http://www.mvps.org/access/tables/tbl0009.htm for
sample code, or download the free J Street Access Relinker from
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

 

[Tom Wickerath]

Zen,

I'm with Doug on this one....Armen's free relinking code is certainly worth
looking into. However, that said, here is my standard blurb on Wizards not
Working, which may help you resolve this issue:

Wizards not working
Try the following steps. You possibly have other wizards that are not
functional as well. Replace three files on your hard drive, Acwzmain.mde,
Acwzlib.mde and Acwztool.mde, using the instructions shown in KB 303769. One
or more of these files may have become corrupted. Do this without Access
running.

http://support.microsoft.com/?id=303769
http://support.microsoft.com/?id=833220 <---Error in loading DLL

1.) Insert the Microsoft Office or Access compact disc.
2.) By using Windows Explorer, open the Pfiles\Msoffice\Office\1033
folder on your CD-ROM or DVD-ROM drive, and locate the
Acwzmain.mde, Acwzlib.mde and Acwztool.mde files.
3.) Select these files, and then click Copy on the Edit menu
4.) Open the folder that you installed Office into. The default folder is
C:\Program Files\Microsoft Office. Select the Office\1033 folder,
and then on the Edit menu, click Paste.

If that doesn't fix the problem, try re-registering the Accwiz.dll,
Msado15.dll and DAO360.dll files.
Click on Start > Run. Then enter the commands:

Regsvr32 Accwiz.dll
Regsvr32 "C:\Program Files\Common Files\system\ado\Msado15.dll"
Regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"

Wizard starts, but “No valid fields can be found†error message may be
related to overly aggressive settings on antivirus software
http://groups.google.com/group/micr..._frm/thread/287b312d799c6739/2543458dbca8ddde
and
http://alexdyb.blogspot.com/2006/02/be-careful-with-kaspersky-anti-virus.html

Access 2003 Users:
BUG: List of currently linked tables may not appear in
Linked Table Manager Wizard in a database in Access 2003
http://support.microsoft.com/?id=835519

Notes:
1. To find Accwiz.dll in Win. XP Professional, I had to make sure to place
a check on Advanced Options in the search dialog, with Search system folders
and Search Subfolders checked.

2. Although I received a message indicating success, when using regsvr32, I
found that the path was not updated. I had to manually update the value of
this key on my PC.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Zen]

Thanks for your suggestions guys, after doing some more troubleshooting it
seems that the link tables are just fine but this new front just wasn't
asking to relink because of another problem that would occur.

Although I will try replacing those three files if some other things don't
work out.

Much appreciated