Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    OLE Automation is moved to the end of the list and Clerk.mdb un-compiles

    I developed front end Clerk.mdb with Access 2000

    On a customer's computer I'm using Microsoft Office Access 2003 (11.8204.8172) SP3
    Default File Format: Access 2000

    I have an Access 2003 installed with Access 2000 front end Clerk.mdb with the following references and everything works OK on a Windows XP computer

    Visual Basic for Applications
    Microsoft Access11.0 Object Library
    OLE Automation
    Microsoft DAO 3.6 Object Library
    Microsoft Visual Basic for Applications Extensibility 5.3
    Microsoft Office11.0 Object Library
    Microsoft Windows Common Controls 5.0 (SP2)
    Microsoft Word 11.0 Object Library
    Tilt 1.2 MultiLabel Type Library
    Microsoft ActiveX Data Objects 2.1 Library

    When I run the same Access 2000 front end program.mdb on a Access 2003 Windows 7 computer I'm getting

    Error: 3044: 'F:\Clerk\Clerk_Be.mdb' is not a valid path. (Note: this is my backend database)

    When I check my Clerk.mdb references they are all checked, however

    OLE Automation is moved to the end of the list and Clerk.mdb un-compiles

    Any help would be appreciated

    Thanks, John
    11397335

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    Have you put the FE database in a trusted location?

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The FE Clerk.mdb is in C:\NbsA2kFe

    I'm familiar with trusted locations in Access 2007 & 2010

    I wasn't aware of trusted locations using Access 2003

    What do I check for?

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    You're quite right, I am wrong.
    It's a longshot but have you installed the hotfix for SP3.
    Is the F: definitely specified.
    When do you get this error, in a form, report?
    Last edited by patt; 2013-02-26 at 17:13.

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts
    After further review IT guy at the site found the solution here:

    PROBLEM - 02/25/13

    When opening fe mdb

    Error: 3044: 'F:\Clerk\Clerk_Be.mdb' is not a valid path. ezy_Session Form_Open

    SOLUTION - 03/09/13

    How to make elevated programs recognize network drives
    http://www.winability.com/how-to-mak...etwork-drives/

Posting Permissions

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