Using a password for data

[Guest]

Greetings, I would like to simply apply a password to the backend and have
the frontend apply the password during startup. I don't feel the need for
any other level of security. What would be the VBA code to do this with my
startup form? Thanks to all!

 

[Chris Mills]

If you are happy with it, the Database Password may suffice.
(Neither I nor anyone else really uses it, though I believe it can be
implemented via Tools, Security, Set Database Password. This will stop casual
snoops.)

I don't know, I suppose one would set the same password on both the FE and BE.
Since almost no-one uses it, I imagine no-one is familiar with (Database
Password) enough to give advice.

User Level Security is the recommended better password system.

However, since both are crackable to the same extent (i.e. ability to search
the internet) it gets a bit depressing.

For one example of how to search the internet for cracking tools, follow the
links here:
http://home.bendbroadband.com/conradsystems/accessjunkie/mdetomdb.html

Chris

 

[Chris Mills]

Further tests (in A2k2) suggest it's best to set the Database Password the
same in both backend and frontend. This really secures it down <giggle>.

If you set a password on the backend and not the frontend (or a different one
on the frontend), it never asks for the backend password after the first time!

If you set the password the same on both, it acts like both are secured (as if
they were the one file) when you enter the one password.

(links were made after "securing". It asked for the password when creating a
link)

This is kinda secure in the sense people would have to bother to download
cracking software (which is free). If they aren't familiar with Access, well,
ignorance is bliss. It's the same as setting a password on a Word doc, for
instance (for which cracks are also free).

Chris