Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    utility.mda Access 2007 (Win XP Access 2007)

    have an application that runs fine under Access 2003 but when I move the application to Access 2007 as an .mdb I have problems with a reference. The app looks for utility.mda, which does not exist. I re-installed the Access 2007, but the problem persists.
    Under Access 2003 the references include a

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: utility.mda Access 2007 (Win XP Access 2007)

    Do you really need the reference to utility.mda? What happens if you remove the reference?

  3. #3
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: utility.mda Access 2007 (Win XP Access 2007)

    I get an error message about the missing reference. After I close the message, the application loads normally. Then, when I attempt to add "on the fly" a new entry for a combo box, I get an error in the VBA window. All of this has worked for years, so I suppose that the utility.mda is necessary.

  4. #4
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: utility.mda Access 2007 (Win XP Access 2007)

    The prior note was with the reference marked as "missing" When I remove the check mark requiring the reference, the application seems to work OK!!! Your thoughts?

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: utility.mda Access 2007 (Win XP Access 2007)

    In general, Access applications don't need a reference to Utility.mda. So I'd leave the reference to Utility.mda unchecked. To make sure, select Debug | Compile <yourprojectname> to see if the code compiles correctly.

  6. #6
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: utility.mda Access 2007 (Win XP Access 2007)

    It looks like no problems. I guess I just carry on with the fingers crossed, as they say. Thanks, as usual.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: utility.mda Access 2007 (Win XP Access 2007)

    If Debug | Compile didn't result in an error message, you shouldn't have anything to worry about (in this respect).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •