Lookup Wizard Won't Run

[MHenry]

I try to select Lookup Wizard on a text field to explore the function
with a simple tabe containing two text fields and an autonumber, but
Access 2000 tells me that I need to run Office or Access setup again,
select Add Remove and select Wizards. I did that three times, but get
the same message when I try to run the Lookup Wizard.

I am trying to have a query look up data from a table and list records
in another table that match the field in the first table.

Any help on one or both issues would be most appreciated.

Thanks,
MHenry

 

[Tom Wickerath]

First, you might want to know that many developers consider lookup fields as being evil:
http://www.mvps.org/access/lookupfields.htm

That said, to fix your wizard try the following steps. You possibly have other wizards that are
not functional as well.

Try replacing three files on your hard drive, Acwzmain.mde, Acwzlib.mde and Acwztool.mde, using
the following instructions. One or more of these files may have become corrupted (see
http://support.microsoft.com/?id=303769 ). Do this without Access running.

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, my next guess is an improperly registered Accwiz.dll and/or
DAO360.dll file(s). Use the directions in steps 4 & 5 to re-register these .DLL files.


Tom
________________________________________


I try to select Lookup Wizard on a text field to explore the function
with a simple tabe containing two text fields and an autonumber, but
Access 2000 tells me that I need to run Office or Access setup again,
select Add Remove and select Wizards. I did that three times, but get
the same message when I try to run the Lookup Wizard.

I am trying to have a query look up data from a table and list records
in another table that match the field in the first table.

Any help on one or both issues would be most appreciated.

Thanks,
MHenry

 

[MHenry]

On Mon, 29 Nov 2004 11:41:26 -0800, "Tom Wickerath"

Hi, Tom,

Pasting over the three files did not work.

Re-registering the files did not work.
(dao360.dll appears in three separate directories,
Service Pack
System32
Common Files

I re-registerd the one in common files.

Is there something else I should try?

Thanks,
MHenry

 

[Tom Wickerath]

(dao360.dll appears in three separate directories,

Service Pack
System32
Common Files

Is the version the same for the System32 and Common Files folders?

Do you have administrative privileges for this PC? If not, this might explain why running set-up
repeatedly does not fix the problem. Off hand, I don't have any more suggestions. Please post the
exact text of the error message(s).

Tom
__________________________________

On Mon, 29 Nov 2004 11:41:26 -0800, "Tom Wickerath"


Hi, Tom,

Pasting over the three files did not work.

Re-registering the files did not work.
(dao360.dll appears in three separate directories,
Service Pack
System32
Common Files

I re-registerd the one in common files.

Is there something else I should try?

Thanks,
MHenry

 

[MHenry]

Is the version the same for the System32 and Common Files folders?

Here is the version information.

C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll =
3.60.8618.0
C:\WINNT\ServicePackFiles\i386\dao360.dll = 3.60.6508.2
C:\WINNT\System32\dllcache\dao360.dll = 3.60.8618.0

Do you have administrative privileges for this PC? If not, this might explain why running set-up
repeatedly does not fix the problem. Off hand, I don't have any more suggestions. Please post the
exact text of the error message(s).

Yes, I do have Adminstrator privileges.

Here is the exact error message.

Microsoft Access couldn't launch the Lookup Wizard.
Rerun the Microsoft Access or Microsoft Office setup program, click
Add/Remove, and select the Wizards check box.

I don't actually have a wizard's check box, I have an icon that looks
like a hard drive and click on it, then select run from hard drive
from the dialog box.

Thanks,
MHenry

 

[Tom Wickerath]

It looks like you have the correct version of DAO360.dll.

Sorry, I don't know the answer to your question. It sounds like this KB article would not apply
(?). Not sure, but you might want to give it a try anyway:

http://support.microsoft.com/?id=207816

Tom
__________________________________

Is the version the same for the System32 and Common Files folders?

Here is the version information.

C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll =
3.60.8618.0
C:\WINNT\ServicePackFiles\i386\dao360.dll = 3.60.6508.2
C:\WINNT\System32\dllcache\dao360.dll = 3.60.8618.0

Do you have administrative privileges for this PC? If not, this might explain why running set-up
repeatedly does not fix the problem. Off hand, I don't have any more suggestions. Please post the
exact text of the error message(s).

Yes, I do have Adminstrator privileges.

Here is the exact error message.

Microsoft Access couldn't launch the Lookup Wizard.
Rerun the Microsoft Access or Microsoft Office setup program, click
Add/Remove, and select the Wizards check box.

I don't actually have a wizard's check box, I have an icon that looks
like a hard drive and click on it, then select run from hard drive
from the dialog box.

Thanks,
MHenry