Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MS Access - adding Utility.mdb

Posted on 1997-04-10
8
Medium Priority
?
1,334 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 150 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
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 

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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses
Course of the Month9 days, 14 hours left to enroll

926 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