Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Nov 2001
    Location
    Sydney, Australia, Australia
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MSQuery not working (2000sp3)

    I've just setup a new machine (XP pro) and can't microsoft query to work. Eg in Excel I choose Data/Get External Data/New Database query. Excel then just hangs with a message in the message bar "waiting for data to be returned from Microsoft query".

    I've tried uninstalling and re-installing office, without success. I have tried both 'installed on first use' and 'run from my machine' in the office setup options.

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

    Re: MSQuery not working (2000sp3)

    Have you checked using Alt+Tab whether there is a dialog window that fails to get the focus?

  3. #3
    Star Lounger
    Join Date
    Nov 2001
    Location
    Sydney, Australia, Australia
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MSQuery not working (2000sp3)

    Have now. No dialog boxes. The Excel program bar has "(not responding)".

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

    Re: MSQuery not working (2000sp3)

    Sorry, I can't find anything relevant.

    You might try to re-install the ODBC drivers to see if that helps. Most are included in Microsoft Jet, see How to obtain the latest service pack for the Microsoft Jet 4.0 Database Engine. Some others come with MDAC, see MDAC Downloads.

  5. #5
    Star Lounger
    Join Date
    Nov 2001
    Location
    Sydney, Australia, Australia
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MSQuery not working (2000sp3)

    I don't know what I did (apart from re-booting a few times) but now it is working. I did change macro security from high down to medium - which might be related? Thanks for your interest.

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

    Re: MSQuery not working (2000sp3)

    Macro security has no bearing on MS Query, but I'm glad it works for you now.

Posting Permissions

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