Getting Warning Message Using VBA MZTools 3.0 in Access 2013

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.
LVL 1
mlcktmguyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.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.
mlcktmguyAuthor 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
Active Protection takes the fight to cryptojacking

While there were several headline-grabbing ransomware attacks during in 2017, another big threat started appearing at the same time that didn’t get the same coverage – illicit cryptomining.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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 (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.
mlcktmguyAuthor Commented:
Yes, I right click the downloaded 'MZTools8VB6Setup.exe' and 'Run as Administrator'.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.
Daniel PineaultPresident / Owner CARDA Consultants Inc.Commented:
I get the feeling you downloaded the wrong version (for VB instead of VBA), try https://www.mztools.com/download_thanks.aspx?productid=MZTOOLS8VBA

Another tool you may like to take a look at might be http://rubberduckvba.com/

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlcktmguyAuthor Commented:
Thank You.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.