Utility.mda issue in Access 2007

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
 
L

Larry Daugherty

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
 
D

David W. Fenton

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.

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

And I think Arvin Meyer is now maintaining the Access Web. Yes?
 
S

Steve Gould

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.
 
D

David W. Fenton

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.

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"...).
 
Joined
May 3, 2013
Messages
1
Reaction score
0
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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top