Solved

Missing utility.mda but cannot turn off the reference!

Posted on 2012-03-26
9
1,869 Views
Last Modified: 2012-08-13
I have been given a database to migrate from Access 2000 to Access 2010.
It is sitting in a trusted location, and I get the infamous "missing or broken reference to the file utility.mda"
I can see it under References, but cannot remove the reference, as  Tools/References is greyed out.
I have had no luck finding an answer on what to do when this is the situation.
can someone please help?
I have spent several days googling to no avail.
0
Comment
Question by:Kilvroch
9 Comments
 
LVL 77

Expert Comment

by:peter57r
Comment Utility
The way to do this is to create a new empty database in A2010 and then use the External Data option to import everything from the existing database.

Using the 'convert' options has not proved to be very succesful in practice.
0
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
<<Tools/References is greyed out.>>

Make sure that your code is not simply paused in 'debug' mode.

From the VBA toolbar:
Run --> Reset

(And from what I've seen, others have resolved this issue by unchecking that reference)
0
 
LVL 57

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
Once you remove the reference, make sure you compile the code to check for errors.  Often, developers years ago would use some of the procedures in the .MDA within their apps.  

  It may be that the reference was simply carried along from something else, or it may be that the app actually used a procedure in the lib which you'll need to deal with if that's the case.

Jim.
0
 

Author Comment

by:Kilvroch
Comment Utility
I'm trying to import the old database into a new one, and get :

you do not have the necessary permissions to use the 'olddatabase.mdb' object. Have your system administrator or the person who created the object establish the appropriate permissions for you.

I am an Admin on the computer where I am trying to install this database.
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Accepted Solution

by:
Kilvroch earned 0 total points
Comment Utility
Update: a colleague has helped me with this - he is still on WinXP and Office 2003. He was able to turn off the reference in his copy of the database, and give me a .mda file to go along with it.

I created a shortcut on my Win7 Office 2010 machine, to open the database with /wrkgrp pointing to the .mda file, and can now open the database.

What an annoying and frustrating thing. One of my goals is to convert this thing to SQL Server and get rid of that stupid Access User / Workgroup stuff

thanks
0
 
LVL 57

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
<<I created a shortcut on my Win7 Office 2010 machine, to open the database with /wrkgrp pointing to the .mda file, and can now open the database.>>

 Your mixing apples and oranges here; utility.MDA was a library of code used by Microsoft in conjunction with Access.   It is not a security work group file.

 You should not be pointing to utility.MDA with the /wrkgrp switch.  If you do, your going to have problems.

Jim.
0
 
LVL 57

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
oops, missed your comment prior to your last.

Jim.
0
 

Author Comment

by:Kilvroch
Comment Utility
that's okay, Jim.... we still haven't solved the core problem, just found a work-around. We've got many more databases to convert and I'm sure we need a 'real' solution to when it is not possible to change the references in an old database.
0
 

Author Closing Comment

by:Kilvroch
Comment Utility
I gave up and used a work around
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

762 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

13 Experts available now in Live!

Get 1:1 Help Now