Conversion of access database to Office 2007

[Marsoe]

My main database does not function properly in access in Office 2007. It
gives a error message saying: Microsoft Office Access-database or the project
missed a reference or contains a broken reference to the file utility.mda"
I am asked to correct the reference, and Visual basic opens, but I have no
idea what to do. Here there seems to be an error (qouted)
Form_Load_Err:
MsgBox Error$
Resume Form_Load_Exit
No idea what to do.

The point is, that access 2007 does not convert older databases properly. Is
there anybody who knows what to do?
Marsoe

 

[Douglas J. Steele]

In what version of Access was your database developed? I believe utility.mda
was part of Access 97, and hasn't been required since.

Go into the References collection and remove the refernce to utility.mda and
see whether it works.

 

[Marsoe]

Thank you Douglas, but Windows could not find the file (yes, I did seach in
system and hidden files as well). My old Office were I was working in Access
was Windows 2000, but I started building the database in the very early days
of Access.

Sincerely,
Marsoe

 

[Douglas J. Steele]

I wasn't suggesting that you look for the file on your hard drive. I was
almost positive that it wouldn't exist on your machine.

What I was suggesting was that you go into the References collection from
within Access and uncheck the reference to utility.mda.

 

[Marsoe]

Ok, where do I find references collection in Acess?
Sorry, it is many years ago I worked with it intensely.
Sincerely,
Marsoe

 

[John Spencer]

-- Switch to VBA window (Type Control+G when in design view)
-- Then in the menu Tools: References

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Marsoe]

I'm impressed. It really worked. Big THANKS to John and Douglas!
Sincerely,
Marsoe

 

[David W. Fenton]

I believe utility.mda
was part of Access 97, and hasn't been required since.

Access 2, actually. There was never any VBA version of Access that
needed a reference to Utility.mda -- features within it could be
used directly without a reference because it was stored in the
program directory.