How can I encrypt the Tables in my Access Application?

K

KmhComputer

Hi,

I need to encrypt the tables in my Access application and I'm not sure how
to do this. The system is written and now the user wants to encrypt the
tables so no one else can see them if they get a hold of the program.

Thanks.
 
K

KmhComputer

Hi,

Thanks for getting back to me so. When you say User Level Security, do you
mean using the User Level Security Wizard? I've never used this function.

So how does that work? Does it ask for a password when running the program?
Does it ask for a password to view a table when not running the program? Do
you know where I find good documentation on this?

Thanks for your help,
Kathy
 
V

Vantastic

Hi Kathy

Yes its the wizard found in Tools.

The gist of how it works is as follows:

You can set user access permissions for all Forms, Tables, Queries, Reports,
Modules etc. You can base these permissions by either individual user, or a
group - ie, Admins, Power Users, Full Data Users etc, or define your own
group.

When a use runs the database, they will be prompted for a password. You must
have set up an account for them initially.

When the wizard is done, it will create a Security.mdw file which is stored
in the same directory as the database, and a shortcut for running the access
database in a secured mode.

This really should be your last step, prior to release. Always make a backup
of your database before you run this wizard. Its not hard to remove user
level security, but its a little tedious.

If you are a running a Server/FrontEnd method, you can use the wizard to
secure only the tables in the server files, but this is quite a mission to
set up effectively (and distribute!)

Plenty of information on this can be found in the normal MS Access Help
file, or even in the newsgroup access.security

I hope this has been some help to you
 
Top