Utility.mda issue in Access 2007

  • Thread starter Thread starter Steve Gould
  • Start date Start date
S

Steve Gould

I have a major problem. We have several hundred Access databases. All have a
reference to utility.mda. Since this is no longer a part of Access we have a
problem. Every database doesn't function properly. Removing the reference
seems to solve the problem.

My question is if there is a way to remove this reference in bulk. I don't
want to have to open and alter the reference in every single database.

Suggestions anyone?

Steve
 
Hi Steve,

No, it will have to be removed individually from each affected
application. However, it would be fairly easy to create a new
application that would step through each application within a scope
that you'll define and to remove the reference to "utility.mda" when
it's found. You may need to check versions so that you don't remove
it in cases where you don't intend.

Not only that but you could be a hero by posting your solution with
Dev Ashish and his folks at www.mvps.orr/access for the benefit of
others who face the same issue.

HTH
 
Not only that but you could be a hero by posting your solution
with Dev Ashish and his folks at www.mvps.orr/access for the
benefit of others who face the same issue.
Click to expand...

As Douglas has said, that's mvps.org/access.

And I think Arvin Meyer is now maintaining the Access Web. Yes?
 
You would think that Microsoft would have programed in the ability to remove
references to utilities that no longer exist when you "convert" a database.
Since a lot of our access databases have not been used in a while (people
never clean up after themselves) I am going to fix the problem as needed.

Thanks for your input.
 
You would think that Microsoft would have programed in the ability
to remove references to utilities that no longer exist when you
"convert" a database.
Click to expand...

I've never had a single database ever that needed a reference to
utility.mda. Why should MS take care of things that you probably
shouldn't have been doing in the first place?

BTW, if you want to use the tools that are still in Utility.mda, you
can use Application.Run("utility.[function you want to use]...)

This is how I programatically launch the ZoomBox, i.e., using
Application.Run("utility.BuilderZoom"...).
 
open access 2007
Create a new db
insert a table
save DB
rename to UTILITY.MDA
move to \windows\system32 folder

open your old db
ups.... it works :dance:
 
Back
Top