Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    2467 Error (A2003 SP1)

    I have hit a bizarre problem with an Access database I have developed for a colleague who works in Rotterdam. On my PC I have no problems at all running the database.

    However, when he runs it on his PC by double-clicking the icon, the application starts OK, but when he tries to open a particular form (which contains a subform), he gets a 2467 Run-time error - The expression you entered refers to an object that is closed or doesn't exist. If he holds down the shift key when starting the database, and then runs the Autoexec macro, there are no errors at all it all works OK.

    I have checked the references & they are all OK, and I have made sure it compiles properly.

    Does anyone have any thoughts as to why this might be happening, and what might be the solution ?

    Thanks for the usual excellent help

    Nick

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

    Re: 2467 Error (A2003 SP1)

    Which service pack level of Access 2003 do you have? And your colleague?
    Does your colleague have the latest version of MDAC installed? (See MDAC Downloads)
    Have you had your colleague check for missing references on his PC?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2467 Error (A2003 SP1)

    Hans

    Thanks for that - I will check up with my colleague on that.

    Nick

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

    Re: 2467 Error (A2003 SP1)

    One more thing to try (it seems unlikely, but you never know): let your colleague set UK number format in his regional settings temporarily (i.e. point as decimal separator and comma as list separator/thousands separator)

Posting Permissions

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