Security of saving odbc password in excel file

BW_HH · 22. November 2023

Does anyone know how safe it is to save username and password for an odbc databse access in an excel-file? Long Version: I have some Excle Files with an ODBC-Connection to a postgresql database. When initilasing the connection it is possible to save the username and password for the access. The password is vsualized with dots, so it is not directly readable. But is the password safed encrypted in the excel file and with which encryption method? Or is it easy to read out the password by knowing how?

MKaiser82

How does ODBC with Excel work under Windows 7 without running Excel as Administrator?

Using Windows XP I didn't need to have admin rights to configure ODBC connections and as well none to use these ODBC connections e.g. in Excel 2010.

Now using Windows 7 I need admin rights to configure ODBC - that's okay. But I also need them to connect via ODBC to my database. When I don't run Excel as admin, the connection doesn't start (there is even no message why not) - I need to start Excel as admin
each time.

Is there no way to use ODBC without starting Excel as administrator? (I would be ok, when the admin password prompt appears when I try to connect to my ODBC data source... but this doesn't happen)...

The main problem why I can't default to run Excel as administrator: I cannot open any Excel-Document e.g. out of the Windows Explorer with Excel. I always have to start Excel first and then use the File-Open-Dialogue to access the Excel sheet.

Information:

I use an IBM ODBC driver for DB2 and Excel 2010, Windows 7 SP1

CharlesKenyon IA

[First post in English]

If you are seeing Save Copy, you are operating with a document on OneDrive or SharePoint.

Try using Word on a file saved to your hard drive rather than the cloud. Any difference?

[End of first post]

Try the F12 key if you are running a desktop version. Try that before the idea of saving and opening from the computer.

Lisa Wilke-Thissen

Hallo Michael,

was vor 30 Jahren seine Berechtigung hatte, ist heute möglicherweise nicht mehr aktuell. Aber manche Mühlen mahlen leider sehr langsam...

Vielleicht hilfts, aber zumindest schadet esnicht, wenn du auf folgender Seite abstimmst:

Saving the labels of caption for each document (and not for all)
– Welcome to Word's Suggestion Box! (uservoice.com)

Viele Grüße

Lisa

aliayat

ES WIRD EMPHOHLEN DIE SEITE ZU BESUCHEN

http://windows.microsoft.com/de-DE/windows-live/account-security-password-information

Pauline R.

Hallo Sebastian,

schau mal, ob das weiterhilft:
http://coding-is-kind-of-magic.blogspot.de/2014/06/onenote-we-need-password-to-sync-this.html

Gruß,

Pauline

Hi,

willkommen im Windows Forum!

Security of saving odbc password in excel file - Similar Threads - Security saving odbc	Forum	Datum
excel password vergessen excel password vergessen: Excel. Passwort vergessen	Microsoft Office	14. Februar 2025
How to Remove Password of PDF Locked Files Without Any Problem? How to Remove Password of PDF Locked Files Without Any Problem?: If you want to unlock your locked file without a problem then this is the best solution that you should try, this OSTTOPSTAPP PDF Unlock Software, is a quick and safe working solution. This...	Software	12. Januar 2024
Wiederholende Savings Wiederholende Savings: Hallo, ich habe diese Tabelle 1 mit akkumulierenden Savings. Tabelle 1:Index...	Microsoft Office	10. November 2023
Quick way to reset Outlook PST file password Quick way to reset Outlook PST file password: The MailsDaddy PST Password Remover Tool is the best solution for users to restore Outlook passwords from PST files. This Outlook password decrypts or cracks PST passwords and unlocks all the...	Software	18. August 2021
word und excel daten per odbc word und excel daten per odbc: Hallo zusammen, ich verwende office 2019 mit word/excel version 1912 klick und los. Eine verbindung per odbc funktioniert mit excel tadellos, mit word hingegen funktioniert der verbindungstest,...	Microsoft Office	30. Januar 2020
Changing the source of linked Excel files in PowerPoint Changing the source of linked Excel files in PowerPoint: Hi, We have the following situation. Many Excel charts are linked to a PowerPoint Präsentation. So far so good. However, the files have to be saved each month into another folder in order to...	Microsoft Office	18. Juli 2019
Problem mit ODBC Abfrage in Power Query (excel) Problem mit ODBC Abfrage in Power Query (excel): Hi alle zusammen, Ich benutze Power Query für Excel (Microsoft Excel 2016 MSO (16.0.6925.1041) 64-Bit) und folgende Fehlermeldung erscheint, wenn ich bestimmte Abfragen machen, wie bspw. die...	Microsoft Office	8. November 2016

Security of saving odbc password in excel file

Security of saving odbc password in excel file

Wie funktioniert ODBC in Excel unter Windows 7 ohne Excel als Administrator zu starten?

Office Word versucht Verbindung zum Drucker herzustellen anstatt einfach die Kopie zu speichern

Beschriftung - neue Bezeichnung

fehler meldung

OneNote 2013 hinter Proxy hat keinen Zugriff auf Notebooks in OneDrive

User Advert

Security of saving odbc password in excel file - Microsoft Office

Security of saving odbc password in excel file - Similar Threads - Security saving odbc

excel password vergessen

How to Remove Password of PDF Locked Files Without Any Problem?

Wiederholende Savings

Quick way to reset Outlook PST file password

word und excel daten per odbc

Changing the source of linked Excel files in PowerPoint

Problem mit ODBC Abfrage in Power Query (excel)

Security of saving odbc password in excel file solved