Linked ODBC password

  • Thread starter Thread starter Lambi000
  • Start date Start date
L

Lambi000

I have a link to a very sensitive payroll file that requires a password. I
would like to hard-code the password into my code so I don't have to have the
users typing it in when accessing the linked file. Is there a way I can do
this?
 
Lambi000 said:
I have a link to a very sensitive payroll file that requires a
password. I would like to hard-code the password into my code so I
don't have to have the users typing it in when accessing the linked
file. Is there a way I can do this?
Click to expand...

In theory you could store the password in your code and then distribute an
MDE so that the code cannot be viewed, but there are now utilities that can
change an MDE back into an MDB. If this data is really "very sensitive",
then users should be typing the password every time. When dealing with such
data convenience is not the correct priority.
 
You have a point. But I am distributing an MDE and that particular app isn't
going to let them see the sensitive data. The problem is that anybody that
can get to the full file will now know the password. I just don't want
anybody to know it. But my application won't let them see it.
 
Lambi000 said:
You have a point. But I am distributing an MDE and that particular
app isn't going to let them see the sensitive data. The problem is
that anybody that can get to the full file will now know the
password. I just don't want anybody to know it. But my application
won't let them see it.
Click to expand...

So why let people get to the "full file"?

Store the password encrypted and decrypt it when used.

Store it in an obscure place and use an obscure method to retrieve it.

Store a less obscure value that appears to be the password that is a
phoney.

It all depends on how much fog you want to disperse and how persistent and
knowledgable the snooper is. That has to be weighed against the sensitivity
and potential damage. You are the only one that can make that assessment.
If someone getting the password means your job then I personally would not
put it in there.
 
I don't think she'll be that persistent. Ok, I'll store it somewhere and
retrieve it as needed.

Thanks!
 
Back
Top