Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Creating a database at work, and it all works fine. Colleague took it home and he gets these errors:-

    Your Microsoft Office Access database or project contains a missing or broken reference to the file MSO.DLL version 2.4
    Run-Time error '3085' - Undefined function 'Format' in expression.

    I got him to get his references, and in his list of references it shows these 2 ticked, but says...

    MISSING: Microsoft Office 12.0 Object Library
    MISSING: Microsoft Word 12.0 Object Library

    These are present in the work version, how do i get these installed on his home pc.

  2. #2
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='Steve_in_Kent' post='772639' date='28-Apr-2009 05:58']Creating a database at work, and it all works fine. Colleague took it home and he gets these errors:-

    Your Microsoft Office Access database or project contains a missing or broken reference to the file MSO.DLL version 2.4
    Run-Time error '3085' - Undefined function 'Format' in expression.

    I got him to get his references, and in his list of references it shows these 2 ticked, but says...

    MISSING: Microsoft Office 12.0 Object Library
    MISSING: Microsoft Word 12.0 Object Library

    These are present in the work version, how do i get these installed on his home pc.[/quote]


    He should untick the two that are marked as missing, then scroll down and check the equivalent names with a lower number, e.g. Microsoft Office 11.0 Object Library.

    This happens when you move a database from a later to an earlier version of Access, e.g. Access 2007 to 2003

Posting Permissions

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