Kilvroch
asked on
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.
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.
<<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)
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)
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.
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.
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<<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.
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.
oops, missed your comment prior to your last.
Jim.
Jim.
ASKER
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.
ASKER
I gave up and used a work around
Using the 'convert' options has not proved to be very succesful in practice.