Re: Conversion of access database to Office 2007

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

-- 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 wrote:
Ok, where do I find references collection in Acess?
Sorry, it is many years ago I worked with it intensely.
Sincerely,
Marsoe

"Douglas J. Steele" wrote:

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Marsoe" <Marsoe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:7573E9D2-233F-429F-A3EF-B9944A195BC9@xxxxxxxxxxxxxxxx
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" wrote:

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Marsoe" <Marsoe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6C55D951-01CB-47AD-801D-B714C796E031@xxxxxxxxxxxxxxxx
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




.

Relevant Pages

  • Re: Rowsource Combobox
    ... Or just pass a reference to the list box, rather than a reference to the ... Doug Steele, Microsoft Access MVP ... Note that depending on how the subform was added to the parent form, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Need another If/then code
    ... The ME is a reference to the form. ... I created the table, added the following code you suggested to the necessary field, and I got an error that says "Can't find macro 'Me' ". ... MS Access MVP ... WHERE XYZ>=MinNum and XYZ<MaxNum ...
    (microsoft.public.access.modulesdaovba)
  • Re: Value isnt valid for text field
    ... you try to enter Mr. Check your reference table. ... Also do you have an input mask or validation set up for the field? ... Jerry Whittle, Microsoft Access MVP ...
    (microsoft.public.access.gettingstarted)
  • Re: Function not available
    ... You're saying that the problem goes away when you remove the reference? ... <MS ACCESS MVP> ... > Correct it appears to be a problem with web components. ...
    (microsoft.public.access.forms)
  • Re: How do you dump the contents of a query into an Excel speadshe
    ... you don't need any additional reference for that code line to work. ... Check to be sure that strFileName has a value, and that, when concatenated ... <MS ACCESS MVP> ... "Ken Snell " wrote: ...
    (microsoft.public.access.queries)