Access 2007

[Rich]

Hi All

Is their a way to set a password to open a form (go to open form and it
prompts you for a password)

Cheers

 

[NetworkTrade]

I do not believe that this is a vanilla embedded Access07 feature; but you
can surely implement it by hiding the form, and then using a button on
another intro form to open it which requires a password to exist correctly in
a textbox of that same form...

 

[Rich]

Thank you NTC, Ok I know how to hide the form but how do I set a password to
open the form from a button

Cheers

 

[NetworkTrade]

well first; don't get me wrong; User based security is an embedded overall
feature in the mdb pre07 Access but with 07 it is not there and you need to
go to the sql product for it....but I can understand one doesn't want to
always take that step so I think alot of us are going to start rolling our
own security.

this isn't perfect and you may need to be more elaborate if the user base is
truly trying to crack you but there is more than one way; a small set of
fixed users could simply be hard coded but probably you want a table with
their passwords...

set a query with the parameter from that form's text box.... then do a
DCount of that query and if =1 then password exists...and allow form to open

you can hide that password table or bury it as a deceptively named column in
an existing column

this is an outline presuming you are ok with a bit of vb and you can review
plenty of Q/A about DCount too...

 

[NetworkTrade]

right right right.... I mistyped the concept....mdb format continues user
level security but accdb does not...and so if it is native 07 accdb, which is
where my head was on this one....there is not user level security....
but even with mdb user level security when it comes to wanting just one form
password protected sometimes people do not want to implement/admin full blown
user level security and thus the roll your own approach may be
appropriate....

 

[NetworkTrade]

well but that is the choice 07accdb does not offer user level security and
if one does not wish to step up to sql server then either step down to mdb or
roll your own... and in the roll your own it is up to the creativity of the
developer....what might be sufficient for nontechnical casual users is
probably insufficient for real hack proofing....