Fatal Exception Error - ftalexceptionerror
last updated on: 11/10/16 08:42AM
   Troubleshoot Embedding the Password into the Microsoft Query Data Source Error [11/10/16 08:42AM]   
Rate this post  

Embedding the Password into the Microsoft Query Data Source

Hello:
Is it possible to embed the password into the Microsoft Query Data Source that you create?  Specifically, in Excel 2007, I'm going to  the Data menu and choosing "From Other Sources" and then "From Microsoft Query".
Afterward, in the "Choose Data Source" window, I choose the SQL data source that I previously created and click the "OK" button. 
The "SQL Server Login" window appears and asks me for my Login ID and Password.  Is there not a way to embed this information in this window so that you do not have to keep entering these credentials?
Thanks!
childofthe1980s

Solutions to the Problem Embedding the Password into the Microsoft Query Data Source

Download SmartPCFixer to Fix It (Free)

If you don't want to type your logon name and password when you use the data source, try selecting the ‘Save my user ID and password in the data source definition’ check box.
The saved password is not encrypted.
If the check box
is unavailable, see your database administrator to determine whether this option can be made available.
Refer the following link for more information on this
http://office.microsoft.com/en-au/excel-help/use-microsoft-query-to-retrieve-external-data-HA010099664.aspx#BMquhowthumbaboutquery_2

Cleaning your computer, components, and peripherals help keep everything in good working condition and helps prevent germs from spreading. You can't image how dirty the inside of your computer case can get. All the dust and dirt is going to prevent proper air flow and may even prevent the fan from working.

Another Safe way to Repair the Problem: Embedding the Password into the Microsoft Query Data Source:

How to Fix Embedding the Password into the Microsoft Query Data Source with SmartPCFixer?

1. You can Download SmartPCFixer here. Install it on your system. When you open SmartPCFixer, it will perform a scan.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed


Related: Download SONY SVE1512H1RB Synaptics PS/2 Port ClickPad driver,Method to Download SONY VGC-LT10E SigmaTel Audio Driver Update v.6.10.5614.0,Way to Download SONY VGN-CS118E/R AV Mode Button Utility v.1.1.01.09140 driver,Method to Download SONY VGN-FW375J/B Alps Pointing Device Driver v.5.7.0.92,Where to Download SONY VGN-NS270J/S Pioneer BD-ROM BDC-TD01 Firmware Update v.1.03,Data Export From Quickbooks To Excel,Date Format In Formula Bar And In The Cell Is Not The Same,Deleted The Snipping Tool,Desktop - Open Program Issues,Desktop Windows Manager Keeps Poping Up & It Reads That There Is A Problem & That Windows Will Check It Out & Send Me An Answer .
Read More: Troubleshoot:EPG updates 3/21/2014 Error,Error "unable to cast the object of type of the 'system boolean to type system string" at startup,Troubleshooter of Error: Error 1325 while installing Flight Simulator X demo,Envelope printing problem in Word 2010,Ending a Process Tech Support,does anyone know what the dialog means "System.Media.FontFamily' threw an exception windows is checking for a solution?,Does Log Me In Ignition for my Android with Windows 7 Home Premium?,Download failure for my Blackberry and the process stops during the install,Display settings keep changing when I come back from sleep mode,Downloaded files are not saved



   Trackbacks

      TRACKBACK URL: http://ftalexceptionerror.blogghy.com/trackback/1056278

   Comments

   Post a comment
Name:


Email:


3 + 1 = ?

Please write above the sum of these two integers

Title:


Comments:





About the author

Contact the author
Categories

Latest blog posts
Troubleshoot Embedding the Password into the Microsoft Query Data Source Error
[11/10/16 08:42AM]
Fast Solution to Error DirectX can t install Internal system error Any solutions
[27/09/16 05:10AM]
How Can You Fix Cannot set Power options to stay where I want them
[14/09/16 04:42AM]
Solved problem with Windows Installer package when trying to install iTunes Win XP pro
[13/07/16 05:35AM]
Tech Support Not loading 3rd party devices
[04/07/16 11:05AM]
Top views posts
How Can You Fix Cannot set Power options to stay where I want them
[14/09/16 04:42AM] Daily Views 2
Fast Solution to Error DirectX can t install Internal system error Any solutions
[27/09/16 05:10AM] Daily Views 2
Troubleshoot Embedding the Password into the Microsoft Query Data Source Error
[11/10/16 08:42AM] Daily Views 2
my internet provider is sask tel i am trying to check all my quarintined e mail
[17/05/16 04:19AM] Daily Views 1
Network how do you get windows vista computer to network with windows 7 computer Anwsered
[14/06/16 04:51AM] Daily Views 1
Photo Albums








Powered by Blogghy

Page generated in 0.0767 seconds.