Error Messages When Opening Databases with Access 2007

[R Marko]

We just purchased a new computer which has Microsoft Access 2007. As we are
planning to update all of our computers to Microsoft Office 2007 (they now
have XP and 2003, can you please help us to resolve the problem.

Although the database, which is housed on the file server, works perfectly
from all other computers, whenever I try to open the "Client Information
Form" using Access 2007, I get the following error messages:

1) When I open up Markosoft and click on “Client Information Form†I
receive this message:

“Your Microsoft Office Access Database contains a missing or broken
reference to the file “utility.mdaâ€

When I request details, it reads:

“The application you are attempting to use has a reference that it cannot
resolve to an object, type library, DLL, or external database. Either the
object, type library, DLL, or database was deleted or renamed. Examine the
Available references list in the references dialog box in the visual basic
editor to determine if any action is required. If you did not create this
application, contact the programmer or administrator of the system.

If the reference listed in the available references list is preceded with
“MISSING:†clear the check box to move the reference if it is no longer
required. “


2) In the forms, New dates under the client call report show “#NAME?â€

3) When I try to put a begin date in, I receive the following error:

“Compile Error – Can’t find project or library.â€


Keep in mind....the database works perfectly from all other computers.

Thank you for any help you can give us.
Rhonda Marko
(e-mail address removed)

 

[Allen Browne]

The error message indicates that there is a file on your other computers
that is not available on the new one.

The file could be an old utility that was part of an (much) older version of
Access, or it could be a set of custom routines used by your database. The
file could be completely missing from your new computer, in the wrong place,
of the wrong version, or inadequately registered.

The solution might therefore be to have the database modified so it does not
use this old file, or to find the custom utility.mda, copy to the new
computer, and register it.

For more information about library references, see:
http://allenbrowne.com/ser-38.html