Results 1 to 3 of 3
  1. #1
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Access freezes when checking References (Access 97)

    I have a problem with a db that I think is a Reference problem (It objects to Dim XL As Excel.Application).

    But whenever the user tries to check References, Access freezes and needs to be closed with Task Manager.

    References are being checked using Tools...References from a module. Is there any other way in?

    They have reinstalled all of Office today, and that did not make any difference.

    I have replaced the Front End file with a new copy, that works OK on my machine, but that didn't help either.

    Any other suggestions?
    Regards
    John



  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access freezes when checking References (Access 97)

    What Windows version are you running? We've seen some odd behavior of Access 97 on Win XP. However, when I've run into this kind of problem, it's usually been resolved by doing a decompile. Have you tried that?
    Charlotte

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Access freezes when checking References (Access 97)

    Thanks Charlotte

    They are running windows98.

    I have just sent them a decompiled /recompiled version, and I will wait to see if it fixes up the problems.
    Regards
    John



Posting Permissions

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