The way to protect access database

[Michael Lam]

I have just created a simple database

How can I protect other for modify the design or directly edit the sources
table but allow them to use the program for update (allow me to do some
admendment with password provided)

Best regards
Michael

 

[TC]

The easiest way to stop users changing the design (code) of your forms,
reports & modules is to generate an "MDE" version of your database. Check
online help for MDE.

To stop your users editing the tables directly - but still let them use
forms & reports that are based on those tables - you would need to implement
"user level security", and use "Run With Owner Permission (RWOP) queries".
This is not a simple undertaking. You should plan to spend >at least several
weeks< to learn the basics of user-level security. Then perhaps a week or
two more, for RWOP queries!

HTH,
TC

 

[Jack MacDonald]

You can protect against unwanted changes to forms and reports by
distributing your database in MDE format. It's in the menu. Be sure to
retain a copy of the original MDB for yourself.

Protecting the table structure is done best through user-level
security. You can find some documentation how to do this in the
website in my signature.

I have just created a simple database

How can I protect other for modify the design or directly edit the sources
table but allow them to use the program for update (allow me to do some
admendment with password provided)

Best regards
Michael

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

 

[Michael Lam]

THx all

I have tried to create an account of admins and users
but there are many options need to set like open , run , execute, for the
form, queries, macros,

Is there any guideline for set the options of each so that the user still
run the program but not edit the data directly
Beside trial run

I have tried to set the sources table to be open and run only, but the
program fail to run.
If I set allow inert, edit .... then the read desinged view option will also
be enabled . So that once the users open the data source table. He or she
can edit the data directly

Now I am using the option of hiding the database table from user but enable
default form for opening and disable all other menu buttons

Is this OK ?

Best regards
Michael

"Jack MacDonald" <[email protected]> ¦b¶l¥ó
¤¤¼¶¼g...
You can protect against unwanted changes to forms and reports by
distributing your database in MDE format. It's in the menu. Be sure to
retain a copy of the original MDB for yourself.

Protecting the table structure is done best through user-level
security. You can find some documentation how to do this in the
website in my signature.

I have just created a simple database

How can I protect other for modify the design or directly edit the sources
table but allow them to use the program for update (allow me to do some
admendment with password provided)

Best regards
Michael

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

 

[Graham Mandeno]

Hi Michael

Have you read the Access Security FAQ? If not, then I *strongly* recommend
you check it out on-line at:
http://support.microsoft.com/support/access/content/secfaq.asp
or you can download a self-extracting file by visiting:
http://support.microsoft.com/?id=207793

Read it, then re-read it, then go to sleep with it under your pillow

 

[Michael Lam]

thx thx
"Graham Mandeno" <[email protected]> ¦b¶l¥ó
¤¤¼¶¼g...
Hi Michael

Have you read the Access Security FAQ? If not, then I *strongly* recommend
you check it out on-line at:
http://support.microsoft.com/support/access/content/secfaq.asp
or you can download a self-extracting file by visiting:
http://support.microsoft.com/?id=207793

Read it, then re-read it, then go to sleep with it under your pillow