Looking for suggestion of database security implementation

[cnlai]

Hello !

I am distributing one application using MS Access. As for its security,
I am thinking this way:

1. For end-users, they can interact with the application throght the
custom menu items provided. They have no access to the tables directly.

2. A developer can have have full access to its tables for setting,
correcting data.
Questions:

1. Do I have to use a user-login system ? If yes, can I set an end-user
to login without a password ?

2. From Q1, I suppose that as a developer I have to furnish a password
to access the tables !?
Thanks for any suggestion.

[Keith Wilby]

cnlai <cn***@pc.jaring.my> wrote:

Questions:

1. Do I have to use a user-login system ? If yes, can I set an end-user
to login without a password ?
The built-in user-level security will require a user name to be supplied
but the password can be blank. User name and password can be supplied as
command line switches.

2. From Q1, I suppose that as a developer I have to furnish a password
to access the tables !?

No, any password can be left blank (with obvious implications).

I thoroughly recommend that you read the MS KB article on security:

<http://support.microsoft.com/default...access%2fconte
nt%2fsecfaq.asp>

There's also a step-by-step example on my web site. Always work on a copy
of your files.

Regards,
Keith.
www.keithwilby.com