MS-Query crashes when trying to retrieve data

Posted on 2006-04-19
Last Modified: 2008-02-26
I have an ODBC source on an Access db that I'm trying to use to get data into Excel. When I get to the 'get data' step in either the pivot table or the 'new database query' wizard, I get an message that msqry.exe has crashed and 'an error log is being generated'. The whole setup works fine in a test environment (different computer, different network)

Two question:
1. Does anyone have any idea why the odbc link should be failing like this?
2. Where is the error log for MS-Query? I've looked high and low, but can't find it.


Question by:rscoville82
    LVL 44

    Accepted Solution

    Hello rscoville82,

    did you try this query in MS Access query design first maybe that will  lead to a clue like a division by zero or some other error at first.

    i think the error is logged in the event viewer you can find it under
    1. go to Start
    2. Click control panel
    3. Double click administrative tools
    4. there should be a shortcut to the event viewer
    5. and you can see errors in the application log

    hope this helps a bit

    Author Comment

    Hi, bruintje

    Thanks for your suggestions! You got me started on the right path.

    After starting with the event viewer, I finally tracked the problem down: Access ODBC links in Windows prior to XP choke on file names that contain periods!

    Appreciate your help!

    LVL 44

    Expert Comment

    glad you got it solved, thanks for the grade :)

    filenames with periods is the same as filenames with spaces, asking for trouble ;-)

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Introduction Perhaps more familiar to developers who primarily use VBScript than to developers who tend to work only with Microsoft Office and Visual Basic for Applications (VBA), the Dictionary is a powerful and versatile class, and is useful …
    My experience with Windows 10 over a one year period and suggestions for smooth operation
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now