Missing MZTools3VBA Reference Error

[Rita]

I'm working on a database that was created in Access 2000. I have Access
2003 on my machine and have recently made updates to the database using the
Access 2003 version. Others in the office have Access 2000 and ever since I
made my updates every time they try to run any of the procedures they get an
error that the project or library can't be found. I have to then go into VB
and remove the Missing MZTools3VBA reference by unchecking it. I'm pretty
sure this is happening cause I saved the changes in Access 2003 and they are
still running Access 2000. Has anyone encountered this type of problem and
know how to fix it so it doesn't happen on a daily basis? Any help would be
apprecatied. Thanks in advance.

 

[Douglas J. Steele]

Do they have MZTools? Is it the same version as you have? If not, remove the
reference before you distribute the application. (Probably a good idea to do
that even if they do have MZTools installed)

 

[Rita]

I don't have MZTools on my machine to my knowledge and I'm 99.9% sure neither
do the other machines in the office. I have unchecked the reference by going
to the VB code Tools->References and I don't get that error coming up anymore
but the error does appear every time the database is opened in Access 2000.

 

[Douglas J. Steele]

I can't imagine why. MZTools is an add-in intended to help developers. It
should never be required in an application. In fact, I didn't realize you
could set a reference to it!

 

[aaron.kempf]

MZ Tools isn't just _ANY_ old developer tool.

It is like the best add-in anywhere for Access VBA and it's _FREEWARE_
right?

-Aaron

 

[Douglas J. Steele]

Correct. http://www.mztools.com/index.aspx

Pretty hard to imagine developing without it, but I still don't understand
why there'd be a reference set to it.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


MZ Tools isn't just _ANY_ old developer tool.

It is like the best add-in anywhere for Access VBA and it's _FREEWARE_
right?

-Aaron