RE: excel qeury disable/enable prompt -- PCTECH

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Eileen (small world <G>),

Are you trying to get the one machine TO prompt, or all the others NOT
TO prompt? 

-Walden 


------------
Walden H Leverich III
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
  


-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx]
On Behalf Of Eileen Keck
Sent: Tuesday, 17 May, 2005 15:10
To: pctech@xxxxxxxxxxxx
Subject: [PCTECH] excel qeury disable/enable prompt

I am using the iseries access ODBC driver to retrieve date into an excel
spreadsheet. I have the spreadsheet stored on a network with all query
definitions in the same folder. All computers except 1 prompt to enable
or
disable the query. I have already tried changing the registry entry
HKEY_CURRENT_USER/SOFTWARE/MICROSOFT/OFFICE/9.0/EXCEL/OPTIONS 

adding the DWORD entry QUERYSECURITY with a value of 0 and still it does
not
prompt.

The machine is running XP Pro

Any Suggestions are greatly appreciated.

Eileen Keck
BlueStar Systems
631-235-4782

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.