Query Protect

L

ldiaz

Hi all.
How can I protect my DataBase of users that pull data from DataBase,I have a
table with user Information, I did a test to pull data from that table to
Excel and all Datas including the Password are converted from ***** to
ldoaz152 and if an user see the password of another person then my DataBase
is vulnerable do not work with appropiate user information.

The Data Base is for purchase purpose and it need to be 100% safe, because
this will contain confidential info and Bank Info.

Could anybody help me to protect my Data Base.

Thanks.
 
M

MacDermott

If you are developing a product for sale to the general public, one that
"need (sic) to be 100% safe, because this will contain confidential info and
Bank Info", and have chosen to do this in Access, you haven't done your
homework. Access doesn't and cannot provide this level of security. It
does have an extensive built-in security system, which is much more
effective than anything you can build yourself, but a quick Google search is
enough to find you products for as little as $10 which will "crack" your
entire security file.
For this level of security, you will need to invest (and have your
customers invest) in a client-server database.
 
Top