?
Solved

MS Query does not run from Open Data Source Dialog Box in Word 2007 for Vista

Posted on 2009-04-14
17
Medium Priority
?
531 Views
Last Modified: 2012-05-06
I have two clients who use mail merge features in Word. One is using Windows XP and the other Windows Vista. Both use 2007 Office System. The clien who use XP doesn't have a problem in creating the recipient list using MS Query. But the one who is using Vista, can not open MS Query when she clicks on the Tools button in the Select Data Source dialog box. I've checked that both have MS Query installed and it can be run manually using the command MSQRY32.EXE.
0
Comment
Question by:behterami
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
17 Comments
 
LVL 23

Expert Comment

by:redrumkev
ID: 24149897
behterami,

How are you doing?

Check this out and see if these ideas work for your vista/office 2007 user:
http://social.microsoft.com/Forums/en-US/sqlserverzhcht/thread/575c38a6-3f9f-41b0-b0f9-41a967cb0800

If the above does not help, is there an error message? If so, what is the exact error message and any error numbers or codes that are given?

Hope this helps,
Kevin
0
 

Author Comment

by:behterami
ID: 24153069
Thank you for your reply. I had already checked that page but there is no point in it to help me. There is no error message in the screen and event log. When I press the Tools button, it drops down to show the options. And after I click on MS Query, the dialog box disappears.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24349460
behterami,

I, like redrumkev, have to ask "How are you doing this?"

When I do a Mail Merge (or Labels or Envelopes) I use an Excel or an Access Source, and it works fine.
I have never had to open "MS Query". (at least not directly)
Nor have I never had to click on the: "Tools button in the Select Data Source dialog box"

I just follow the wizard.
I can filter and sort the list through the wizard's dialog boxes with no problem.

If you are trying to use a "List Table" in Word as your mail merge source, then please be aware that since office 2003, the recommended way of doing Merges has been to use an external source.
(MS Access, MS Excel, ODBC source)
Again, using an Access or an Excel source for merges, I have never had any problem with any combination of Office and/or Windows versions.
;-)

JeffCoachman
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24349476
Oh, and also you may want to make sure that Office 2007 is up to Service Pack 2 (released on April 24, 2009)
And Vidows Vista is at SP1.
0
 

Author Comment

by:behterami
ID: 24350428
I am using Vista SP1 and updated Office 2007 to Service Pack 2 recently. The problem still presists.
I create a mail merge is through the Wizrd. I go forward two septes and then in the step to "Select recipients" I click on Browse to "use an existing list". This is the way all team do to create the mail merge. Amazingly, it works for the people who are using Windows XP SP3 regardless of what Office they have. I mean it works both for Office 2003 and 2007 when OS is XP or even Windows Server 2003.
We use Tools to launch MS Query to create list of recipients from an ODBC database. I confirms, this method is working currently for all other users except thoes who have Vista and Office 2007.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24350622
...and what happens if you simply select "ODBC" from the dropdown list?


untitled.JPG
0
 

Author Comment

by:behterami
ID: 24370899
Thank you for your help.
Please look at the screen shots in order.
screen1.jpg
screen2.jpg
screen3.jpg
screen4.jpg
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24370982
Hmmm.

Ok, this set of screens looks like it has changed in Vista.

I don't know what to suggest at this point.

Is it possible to link the data source into access as a linked table?
Then perhaps then we can use Access as the source.

JeffCoachman
0
 

Author Comment

by:behterami
ID: 24371120
Unfortunately not. It's a data source that has been there for years and my clients are used to creating the mail merge in this way. As this is only a problem of Vista users I can not ask them to use different methods.
Could it be a security issue in Vista that prevents launching MS Query from Word?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24371332
<Could it be a security issue in Vista that prevents launching MS Query from Word?>
...Perhaps, who knows?
;-)

It would not hurt to try disabling UAC (User Access Control)
http://www.howtogeek.com/howto/windows-vista/disable-user-account-control-uac-the-easy-way-on-windows-vista/

Jeff
0
 

Author Comment

by:behterami
ID: 24380421
I disabled UAC and tested, but no success. Any other idea?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24380900
Contact vendor that supplied the ODBC Driver and see if they have an updated version of the drivers for Office 2007/Vista
0
 

Author Comment

by:behterami
ID: 24392311
They say It's the lates version.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 1500 total points
ID: 24392803
The it may be time to put in a call to Microsoft.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

650 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