[AccessD] MZTools and Windows 7

Arthur Fuller fuller.artful at gmail.com
Fri Mar 26 09:43:38 CDT 2010


For the last several years, I have used MzTools within the Access editor,
and grown so addicted to it that it's hard to imagine a VbA-progamming life
without it. I've customized its templates to my liking, I've added new
templates for such snippets as declaring and manipulating DAO and ADO
recordsets, etc.



Recently I updated the OS on my laptop to Windows 7. After that, I attempted
to install MzTools (which is accomplished by opening a command window and
then running the command "regsvr32 mztools3vba.dll". To my shock and horror,
I received a message saying that mztools was loaded but not registered in
the registry. Which means ultimately that Access won't know it's there.



Has anyone faced this problem and discovered a workaround?



Strangely enough, MzTools runs fine on my desktop, which runs Windows Server
2008. I searched its registry and found two items:



MZTools3VBA.Connect

MZTools3VBA.UserDocumentResults



Might it work if I manually enter these nodes and their values in the
Windows 7 registry? I'm afraid to work directly with the registry since it's
risky.



Any advice is appreciated. In the worst case, I suppose that I can copy the
MDB of interest back to my desktop, run Access and MZTools there and update
the headers etc., then copy it back to my laptop, but that choice leaves a
bad taste in my mouth.



TIA,

Arthur



More information about the AccessD mailing list