Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default MS Query - DB connection

Currently I have a number of MS Queries connected to an Oracle DB through
the ODBC. We have had to change the user name and password for accessing
the database so I need to change the queries.
How?
The ODBC setup on the PC has been changed but each of the queries still
access via the original id, is there a way in the query editor to change
these details?

--
Regards Dean

www.dkso.co.uk/
http://homepage.ntlworld.com/dkso


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Network connection for query ken Excel Discussion (Misc queries) 0 February 12th 10 07:43 AM
Connection of Excel 07 pivot table to Access Query makes DB read o Chuck W[_2_] Excel Discussion (Misc queries) 0 October 9th 09 03:45 PM
Relative path in database query connection string DanL Excel Discussion (Misc queries) 1 February 20th 09 06:09 PM
External data connection needs separate login for each query MikeP Excel Discussion (Misc queries) 1 December 8th 08 07:29 PM
Change Connection of a Query Jean-Francois Excel Discussion (Misc queries) 1 October 6th 05 12:16 AM


All times are GMT +1. The time now is 11:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"