Solved

Missing utility.mda but cannot turn off the reference!

Posted on 2012-03-26
9
1,909 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
ID: 37765885
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
ID: 37765891
<<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
ID: 37765928
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
ID: 37766111
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Accepted Solution

by:
Kilvroch earned 0 total points
ID: 37766196
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
ID: 37766259
<<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
ID: 37766271
oops, missed your comment prior to your last.

Jim.
0
 

Author Comment

by:Kilvroch
ID: 37767514
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
ID: 38152228
I gave up and used a work around
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
View vs Edit mode enhancements 12 40
Explanation of Access VBA code 2 36
Storing Combo Box Selection in Table 12 42
can't find file error on web browser 1 13
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
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…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

911 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

22 Experts available now in Live!

Get 1:1 Help Now