Solved

MS Access - adding Utility.mdb

Posted on 1997-04-10
8
1,276 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
 

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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DVI Ports 14 89
Communication with an active RFID 7 63
Do you need to have Windows Firewall on if you have a hardware firewall 9 75
PC build question 3 50
We recently endured a series of broadcast storms that caused our ISP to shut us down for brief periods of time. After going through a multitude of tests, we determined that the issue was related to Intel NIC drivers on some new HP desktop computers …
Stuck in voice control mode on your Amazon Firestick?  Here is how to turn it off!!!
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

863 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

Need Help in Real-Time?

Connect with top rated Experts

29 Experts available now in Live!

Get 1:1 Help Now