Solved

MS Access - adding Utility.mdb

Posted on 1997-04-10
8
1,284 Views
Last Modified: 2008-03-06
I need to know how to install utility.mda (needed by MS ACCESS)?  We tried by going into ACCESS and using the add-in manager.  When we select utility.mda for "activiation" it is added to the available list (with an X next to it indicating it is to be installed).  However, when we close (the only way to exit the add-in manager) -- the add-in is not made active.  We know this because:
      1.  sendkeys (an MS ACCESS macro capabilty) continues
          to complain that the utility add-in needs to be installed
      2.  when we go back into the add-in manager, the utility
          add-in in no longer in the available list?
 We have uninstalled  and reinstalled Access with all available option but the problem still presists.

Can you please help?

Thanks
Sirak


0
Comment
Question by:Sirak
  • 4
  • 4
8 Comments
 

Author Comment

by:Sirak
ID: 1008669
Edited text of question
0
 

Author Comment

by:Sirak
ID: 1008670
Edited text of question
0
 
LVL 3

Accepted Solution

by:
ChrisLewis earned 50 total points
ID: 1008671
The Utility.MDA is referenced in the MSACC20.INI file [Options]
SystemDB=C:\ACCESS20\system.mda
UtilityDB=C:\ACCESS20\utility.mdaIn Access 95/97 it's in the Registry[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Access\Options]
"UtilityDB"="C:\\Program Files\\Microsoft Office\\Office\\utility.mda"
Hope this helps!Chris!

0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:Sirak
ID: 1008672
I checked the setting in the registry as you suggested and everything matches but on the line [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Access\Options instead of ...\OFFICE\8.0\ACCESS I HAVE "...\OFFICE\7.0\ACCESS.
0
 
LVL 3

Expert Comment

by:ChrisLewis
ID: 1008673
Also, Utility.MDA should NOT be listed in the Add-ins!Chris!
0
 
LVL 3

Expert Comment

by:ChrisLewis
ID: 1008674
Also, Utility.MDA should NOT be listed in the Add-ins!Chris!
0
 

Author Comment

by:Sirak
ID: 1008675
I checked my registry......

Utility.mda in not set in any other registry folder.  It is only set in ...\Microsoft\7.0\Access\Options


0
 
LVL 3

Expert Comment

by:ChrisLewis
ID: 1008676
First of all, ignore the 7.0/8.0 thing in the registry.  If you are referencing a valid Utility.mda in the UtilityDB Key of the Registry, then Utility.MDA is loadingI still don't know why you are trying to install Utility.MDA, since Access does it for you.If you want, e-mail me.ChrisChris@TAYLORMGMT.COM
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is about my first experience with programming Arduino.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question