Missing utility.mda but cannot turn off the reference!

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.
KilvrochAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

peter57rCommented:
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
mbizupCommented:
<<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
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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
Acronis Data Cloud 7.8 Enhances Cyber Protection

A closer look at five essential enhancements that benefit end-users and help MSPs take their cloud data protection business further.

KilvrochAuthor Commented:
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
KilvrochAuthor Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<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
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
oops, missed your comment prior to your last.

Jim.
0
KilvrochAuthor Commented:
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
KilvrochAuthor Commented:
I gave up and used a work around
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.