If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Microsoft Query could not be started because it isn't installed
I have found an answer to this difficulty. I happen to have MS Works on my
system & using the files MSQRY32.EXE & QRYINT32.DLL from Works to replace the files of the same name in MS Office I now can access MS Query in MS Excel 2000 through Data | Get External Data | New Database Query. The two files of have the same name but different date/time stamps & volumes in each suite. Malcolm Walker "MalcolmW" wrote in message ... A couple of days ago I posted the message hereunder in the excel.general group & there has not been a response. Had I been more observant in looking at the list of groups I am sure it would have been more appropriate to post my message here & I am hoping for some kind of helpful reply! This is my message: I have Excel 2000 SP3 & Windows XP Home. When I go to Data | Get External Data | Run Saved Query I can import data from an Access database into an Excel worksheet. When I go to Data | Get External Data | New Database Query after a delay a message appears to tell me that MS Query is not installed. This is the message: "Microsoft Excel "Microsoft Query could not be started because it isn't installed. You can install Query by running the installation program you "used to install Office or Excel. The Query option is in the Office Tools category. "OK" However MSQRY32.EXE is in the Office folder & I have reinstalled it by renaming it to .old & running the Add/Remove facility in the Office installer to no avail. I have also installed the complete set of Office Tools without any change in the above-mentioned behaviour. I have run Detect & Repair again with no change. I have searched the MSKB & found an article at: http://support.microsoft.com/default...b;en-us;179686 that refers to this problem but in Microsoft Excel 98 Macintosh Edition. Nevertheless I have tried the resolutions from the article again to no avail. When trying to start MS Query by double-clicking MSQRY32.EXE apart from the display blinking MS Query does not open. Task Manager both in applications & processes does not show that it is running. It seems to me that as a Saved Query can be run that Query is installed & that some other element that Excel, Query & Access need for a New Database Query is either absent or not available. Can anyone help with this difficulty please? Malcolm |
#2
|
|||
|
|||
Hi,
I had a quick look at this on Excel 2000 SP3, and note that when you choose "Data | Get External Data | New Database Query", it enumerates ODBC sources and then offers them. On my system it's fast, and works perfectly, but I wonder if your ODBC was messed up in some way? You can check it under "Administrator Tools" on the start menu of Windows 2000, not sure where it would be on XP. Maybe the fact you had Works has messed up the registry mappings? I don't recommend running Works and Office on the same PC. MalcolmW wrote: I have found an answer to this difficulty. I happen to have MS Works on my system & using the files MSQRY32.EXE & QRYINT32.DLL from Works to replace the files of the same name in MS Office I now can access MS Query in MS Excel 2000 through Data | Get External Data | New Database Query. The two files of have the same name but different date/time stamps & volumes in each suite. Malcolm Walker "MalcolmW" wrote in message ... A couple of days ago I posted the message hereunder in the excel.general group & there has not been a response. Had I been more observant in looking at the list of groups I am sure it would have been more appropriate to post my message here & I am hoping for some kind of helpful reply! This is my message: I have Excel 2000 SP3 & Windows XP Home. When I go to Data | Get External Data | Run Saved Query I can import data from an Access database into an Excel worksheet. When I go to Data | Get External Data | New Database Query after a delay a message appears to tell me that MS Query is not installed. This is the message: "Microsoft Excel "Microsoft Query could not be started because it isn't installed. You can install Query by running the installation program you "used to install Office or Excel. The Query option is in the Office Tools category. "OK" However MSQRY32.EXE is in the Office folder & I have reinstalled it by renaming it to .old & running the Add/Remove facility in the Office installer to no avail. I have also installed the complete set of Office Tools without any change in the above-mentioned behaviour. I have run Detect & Repair again with no change. I have searched the MSKB & found an article at: http://support.microsoft.com/default...b;en-us;179686 that refers to this problem but in Microsoft Excel 98 Macintosh Edition. Nevertheless I have tried the resolutions from the article again to no avail. When trying to start MS Query by double-clicking MSQRY32.EXE apart from the display blinking MS Query does not open. Task Manager both in applications & processes does not show that it is running. It seems to me that as a Saved Query can be run that Query is installed & that some other element that Excel, Query & Access need for a New Database Query is either absent or not available. Can anyone help with this difficulty please? Malcolm -- Gerry Hickman (London UK) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Taher | Setting Up & Running Reports | 1 | August 31st, 2004 09:07 PM | |
How Microsoft Office Tech Support (In Reality Convergys of Ohio) is a Miserable Failure and Oxymoron | Chad Harris | General Discussions | 0 | May 29th, 2004 09:54 AM |
completely delete office2000 | jason | Setup, Installing & Configuration | 1 | May 28th, 2004 10:08 AM |
office 2000 remove tools | bud | Setup, Installing & Configuration | 1 | May 27th, 2004 10:40 AM |