Passwords on Access

[Simon]

I have a shop database, is there way to restrict/ and put passwords on
certain forms,

As i do not want staff to see profit

 

[Tom van Stiphout]

On Thu, 24 Dec 2009 04:09:57 -0800 (PST), Simon <[email protected]>
wrote:

Yes. The simplest and not necessarily most secure way to do this is to
write a few lines of code in the Form_Open event of such forms:
if InputBox("What's the password?") <> "myPassword" then Cancel = True

Make sure you distribute your application as a compiled version: MDE
or ACCDE or ADE.

-Tom.
Microsoft Access MVP

 

[John W. Vinson]

I have a shop database, is there way to restrict/ and put passwords on
certain forms,

As i do not want staff to see profit

It sort of depends on how inquisitive and how skilled the staff are. It's
probably impossible to make a desktop Access database really secure against a
skilled and determined hacker, but on the principle that "locks are to keep
out honest people" you can use Tom's suggestion to require a password on
opening a form.

The next step up would be version dependent. If you have A2003 or earlier, you
can implement "Access Workgroup Security". Download the Microsoft Access 2000
Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Read it carefully. Get a good night's sleep. Read it AGAIN, even more
carefully. Back up your database, and follow the instructions scrupulously.
You'll need to secure both the frontend (with the forms, reports, etc.) and
the backend (with the tables) - if you don't have the database split in this
way, *do it*, regardless of the security issue!

A2007 has removed the ability to create a secured database, although if you
use .mdb format files (rather than the newer .accdb) it still supports
security.