[AccessD] MZTools and Windows 7

Darren - Active Billing darren at activebilling.com.au
Sun Mar 28 18:04:52 CDT 2010


Hi Arthur
Not sure where you are up to with this
We have an install we run by registering a DLL too.
It fails on Win7 - Just as you describe
The solution with the issue we have found was in permissions.
Despite being a full rights administrator I discovered I had to create a
batch file with the reg server command then 'right click' this batch file
the select Run As Administrator"
Even then a re-boot was required - not impressed 

Many thanks
 
Darren
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Saturday, 27 March 2010 1:44 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] MZTools and Windows 7

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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list