ACCESS 2010 can't find ACWZTOOL

[cptNemo]

Hello,



I have a problem with one ACCDE: it doesn't want to open correctly on some machines running 2010 SP1 32-bit (but it does correctly with the very same file on other machines, also running 2010 SP1 32-bit). The error appears as soon as one tries to open the db: ACWZTOOL is not found. Then within the db, when clicking on a button which contains VBA code the error: "Requested type library or wizard is not a VBA project. *The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]. *There may have been an error evaluation the function, event, or macro."

I have searched around and there is a huge 'literature' on the error 'Requested type library or wizard is not a VBA project'. I have tried different solutions: among them I recompiled the ACCDE on different computers. I also tried to recompile the ACCDE from the original ACCDB on the very same machine that it gives me the error. Strangely enough the 'missing ACWZTOOL' error also appears when opening the ACCDB on the problematic machines...

Any idea? Should I try to embed the VBA library in the db?

Thanks

[ssanfu]

Maybe this will help

https://www.accessforums.net/access/...ned-25836.html

[cptNemo]

Maybe this will help

https://www.accessforums.net/access/...ned-25836.html

I don't think so. There is referring to a difference in version (32 and 64-bit). But in my case ACCDE was create on 32-bit and the error appears also on a 32-bit version.

Is there any point in redesigning the database importing the tables? How could I make sure the library used in the ACCDE do not need ACWZTOOL or other libraries?

[ssanfu]

OK....

If you run the accmdb on the problem computer, does the error still occur?
Or maybe the ACWZTOOL.EXE file is corrupt.

I did a search for ACWZTOOL and found two files in different directories. You could copy the ACWZTOOL.EXE from a computer that does not have problems to the computer with problems.

[cptNemo]

If you run the accmdb on the problem computer, does the error still occur?

Yes.

What if I deselect ACWZTOOL from the available references? What is its function anyway?

[ssanfu]

As far as I can tell, it is one of the Access wizard toosl. There are several opinions about deselecting/deleting it.

Googling "ACWZTOOL", I found:


**** http://obieosobalu.wordpress.com/201...fice-2010-sp1/


info on wizards
http://support.microsoft.com/kb/208307/en-us
http://answers.microsoft.com/en-us/o...0-266fad0bb80b
http://www.pcreview.co.uk/forums/acw...-t2231589.html
http://eis.bris.ac.uk/~ccmjs/accesswizard.html