Cannot install MS Query

[Jonck van der Kogel]

Hi everybody,
I am attempting to get ODBC working on my Mac, so that I can integrate
MySQL with Excel. I managed (after a lot of work compiling the driver
from source, first time for me as an old school Mac user) to get the
MyODBC drivers installed, so now all that remains is installing MS
Query. So I downloaded the MS Query installer, but for some reason it
will not install. Every time I get the message that MS Office X cannot
be found, though it clearly is installed.
It gives some uninstall information on what to remove from where
should you want to uninstall, so my guess is that manually placing
those items in the correct positions will install MS Query.

However, I cannot reach the items manually in the installer. I
remember an old utility that was handy in the OS 9 days, TomeViewer,
which allowed you to look inside "tomes" and manually install items
that way. Does anybody know of a utility that will allow me to
manually install the items contained by the MS Query installer? Or
does someone have a link for me where I can download the items without
an installer?

Any help is much appreciated, Jonck

 

[Jim Gordon MVP]

Hi

If you installed MS Query after running the office updates it might be
necessary to run the updates again.

Be sure to use Disk Utility First Aid to repair permissions after installing
or running updates.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

 

[Jonck van der Kogel]

Hi Jim,
Thanks for the reply. I tried your suggestion, ran repairpermissions,
but the MS Query installer is still complaining that Office X is not
installed. Could it be a problem that I don't have Office X installed
to the "Applications" directory of my boot volume?
The reason I don't have it in the Applications directory on my boot
volume is because I have an old Mac (9600) and OS X is installed on a
4GB HD. Needless to say this does not leave me enough room to have all
my applications reside on the HD as well, especially since the user
manual suggests leaving at least 1GB of free space on your boot volume
for a swap file. Therefore most of my applications are on a seperate
HD. Most installers have a "custom install" option, that allows you to
choose the location and what to install. However, the MS Query
installer only has the "easy install" (ha!) option. Therefore when I
start up the installer it says it's going to install to my boot volume
while I know full well that no Office X can be found there. After
hitting ok, it does say that it's scanning all my HD's, not just the
boot volume. In fact it scans the volume Office X is on for a short
period but quickly comes to the conclusion that Office X is not
installed.

Any ideas? I'm pretty much stumped here, and pretty dissapointed,
since MS Query was the whole point of my spending a lot of time
getting the MyODBC drivers compiled and installed.

Thanks for any help,
Jonck

 

[Jim Gordon MVP]

I really hate it when installers try to outsmart the owners of the
computers. Maybe you can fool the installer by creating an alias to your
Office X installation and put the alias into the applications folder of
your boot drive. Try it and see what happens.

-Jim

 

[Jonck van der Kogel]

Thanks again, good suggestion. Regretfully the installer was not
fooled and still complained that Office X was not installed. I then
figured that perhaps if I just copy Office X to the Applications
folder, install Query and then put Office back in its original
position it might work, but this did not work either. I guess Office
really needs to be installed to a certain location and cannot then be
manually moved.

How large is the MS Query application? If it's small, do you think you
could mail it to me, so I could then just put it in the correct
location and see if that works? Or do you think that will not work?

Thanks very much for your help, Jonck