MS-Query crashes when trying to retrieve data

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.

Thanks

scooby-doo
rscoville82Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bruintjeCommented:
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
bruintje
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rscoville82Author Commented:
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!

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

filenames with periods is the same as filenames with spaces, asking for trouble ;-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.