UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Password/encrpt Front End So That It Doesn't Always Prompt For The Password, Access 2007    
 
   
Lateral
post Jul 16 2017, 06:59 PM
Post#1



Posts: 120
Joined: 29-November 13



Hi guys

I have implemented security in my Access 2007 application and it is working really well. I have a BE/FE environment.

The issue I have is that if I convert the FE to and ACCDE and then open it with a text editor, it is very easy to "see" any passwords.

From my understanding, I need to also Encrypt the Front End with a password.

I have done this and it solves the issue of being able to view the password via a text editor but every time I open the accde file, it prompts for the password...this is not what I want to happen.....I don't want it to prompt.

Am I missing something here?

Thanks for your help.

Cheers
Go to the top of the page
 
theDBguy
post Jul 16 2017, 10:13 PM
Post#2


Access Wiki and Forums Moderator
Posts: 70,254
Joined: 19-June 07
From: SunnySandyEggo


Hi,

Perhaps rather than encrypting the file, you could try simply encrypting the passwords.

Just a thought...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
Lateral
post Jul 16 2017, 11:51 PM
Post#3



Posts: 120
Joined: 29-November 13



Hi dbGuy,

Thanks for the reply.

Can you please clear something up for me?

I had assumed that if I create an "accde" file for my FE that it effectively stops it being opened in the Developer Version of Access.....I have done some testing and I can open an "accde" in developer mode and change queries and macros but not the other stuff.....is this how it should be working or am I missing something again?

I was expecting that an "accde" file couldn't be opened by the Developer environment.

Cheers
Go to the top of the page
 
theDBguy
post Jul 17 2017, 12:18 AM
Post#4


Access Wiki and Forums Moderator
Posts: 70,254
Joined: 19-June 07
From: SunnySandyEggo


Hi,

Compiling to a ACCDE only protects form and report designs and your VBA code. It does not prevent modifications to table and query designs.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
Lateral
post Jul 17 2017, 12:21 AM
Post#5



Posts: 120
Joined: 29-November 13



Thanks DbGuy

That clear that up.

Another question regarding encrypting/password protecting an FE...

What use is it to add a password and encrypt an FE if you need to supply the user with the password anyway in order to run it?
Go to the top of the page
 
DanielPineault
post Jul 17 2017, 07:04 AM
Post#6


UtterAccess VIP
Posts: 5,022
Joined: 30-June 11



It stops others from being able to open/use the database.

You may like to review: Securing Your MS Access Database Front-End

--------------------
Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this".
* A user interface is like a joke, if you have to explain it, it's not that good!


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...
Go to the top of the page
 
theDBguy
post Jul 17 2017, 10:47 AM
Post#7


Access Wiki and Forums Moderator
Posts: 70,254
Joined: 19-June 07
From: SunnySandyEggo


Hi,

As Daniel said, encrypting the database only allows those who you give the password to open the database. Others won't be able to open the database, if you don't want them to, without the password. Cheers!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
Lateral
post Jul 17 2017, 05:14 PM
Post#8



Posts: 120
Joined: 29-November 13



Hi guys

Thanks for the replies.

Ok, I think I now better understand how this all works.

By encrypting and adding a password and the creating the FE as an accde file, it encrypts sensitive data in the accde file such as password etc.

The problem now is that access 2007 doesn't support the /PWD command line....so how do I pass the password when the user starts the FE?

Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    24th July 2017 - 01:35 PM