We help IT Professionals succeed at work.

Getting Warning Message Using VBA MZTools 3.0 in Access 2013

244 Views
Last Modified: 2018-10-24
I purchased and have been using VBA MZTools 3.0 for many years, since developing in Access 2003.  It is a great product.

I am now developing in Access 2013 and have upgraded some of the old 2003 apps to 2013.

MZ tools seems to wok fine but whenever I exit Access I get a message:

'VBA MZ-Tools 3.0' has caused an access violation'.  Remove it from the list of available Add-Ins?'

I can then click Yes, No or Help.  Pressing Help takes me to a Microsoft Docs page for Visual Studio 2012 but doesn't really explain the issue.  At least not that I see.

Is there some way to get rid of the message I'm getting when I exit while using Vers 3?  Is there any problem with continuing to use vers 3 if I just answer 'No' to the prompt I get every time I exit Access?

I figured I'd for sure gotten my moneys worth out of vers 3.0 so I decided to move to the newest version.  I didn't see any versions specific to VBA so I downloaded 'MZTools8VB6' but when I try to install it I have an issue.
Comment
Watch Question

Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
Is there some way to get rid of the message I'm getting when I exit while using Vers 3?  Is there any problem with continuing to use vers 3 if I just answer 'No' to the prompt I get every time I exit Access?

 No way to get rid of the message. There was a change required for the 3.0 version to work with later versions of Access.  Just answer no to the prompt.

I didn't see any versions specific to VBA so I downloaded 'MZTools8VB6' but when I try to install it I have an issue.

  Not sure what's up with that...it should work fine.

Jim.
Daniel PineaultPresident / Owner CARDA Consultants Inc.
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
I've used Mz_Tools (VBA V3 was free) for years and I too, and others, have encountered this error.  To my knowledge there is no fix.  You'd need to upgrade/buy version 8.

Author

Commented:
Thanks Jim, I like Vers 3.0 and it does what I need it to do.  I use it heavily to insert Error handling.

Good ot know it's not causing issues other than the annoying message.

When I try to install Ver 8 for VB6 I get ot the screen below.




It looks good but I canot click in the box to select the component I want to install so the 'Next' button is never enabled.
EEMZToolsIsue.jpg
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
There was a fix, but Carlos took it down when he started charging and it was only available for a short time.   Not many have it.

Jim.
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
When I try to install Ver 8 for VB6 I get ot the screen below.

 Just as a shot in the dark; are you doing a right click and "Run as admin"?

Jim.

Author

Commented:
Yes, I right click the downloaded 'MZTools8VB6Setup.exe' and 'Run as Administrator'.
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
Do you have 64 bit Office?   not sure what flavors MZ tools comes in.

 Outside of that, out of ideas as I don't have it here.  

Jim.
President / Owner CARDA Consultants Inc.
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank You.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.