password for *.mdb is visible in notepad?!

How to hide password that connects to the database

Page 1 of 1

2 Replies - 2872 Views - Last Post: 09 February 2009 - 01:40 AM Rate Topic: -----

#1 domagojbulat  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 08-February 09

password for *.mdb is visible in notepad?!

Posted 08 February 2009 - 09:20 AM

Hi,

I just published VB 2008 application and opened it with notepad.
From there I can clearly see what is the password for connection to the mdb database. :blink:
I don't want the users to see this password.
How to make a more securely connection with VB 2008 to Access?

Thanks a bunch!

Is This A Good Question/Topic? 0
  • +

Replies To: password for *.mdb is visible in notepad?!

#2 Core  Icon User is offline

  • using System.Linq;
  • member icon

Reputation: 774
  • View blog
  • Posts: 5,097
  • Joined: 08-December 08

Re: password for *.mdb is visible in notepad?!

Posted 08 February 2009 - 12:39 PM

What file did you open that shows the password. Unless you are storing the password in a text file, all the passwords in the application code are hidden.
Was This Post Helpful? 0
  • +
  • -

#3 domagojbulat  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 08-February 09

Re: password for *.mdb is visible in notepad?!

Posted 09 February 2009 - 01:40 AM

View PostCore, on 8 Feb, 2009 - 11:39 AM, said:

What file did you open that shows the password. Unless you are storing the password in a text file, all the passwords in the application code are hidden.


At first, thanks for your interest! I am pleasently surprised to see someone willing to help. Even if we don't fix this, I am happy! And sorry for not writing you back immediately, I must have been sleeping - it seems we have a bit time difference.

Password is automatically put in code when making connection to database:

connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\putni.mdb;Persist Security Info=True;Jet OLEDB:Database Password=smile"

After publish, I go to:
C:\Documents and Settings\user\Local Settings\Apps\2.0\56LMOD80.RHX\MC6L602D.DX0\doma..tion_e0f8bf0290820f50_0001.0000_907563d72fdbcebd
(Project name is Domagoj)

There I select Domagoj.exe and drag it into an opened notepad.
In notepad if I try ctrl+F with keyword "password", i get:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\putni.mdb;Persist Security Info=True;Jet OLEDB:Database Password=smile

Btw, is there a way to publish so that user can select in which folder to install the application?
For now, I can only install to this strange location in Documents and Settings\user\...\...
It wold be nice to put it in C:\Program Files\NewFolder\
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1