Protect Database Design

[Sherry]

How can I protect the design of my objects in an Access
2003 database? I want my users to be able to insert,
delete, and modify data, but I do not want them to be
able to change the design of an object, nor delete an
object.

Thanks,
Sherry
Rome, GA

 

[Roger Carlson]

Save the database as an MDE file from the Tools > Database Utilities menu.
See Help for more information. However, keep a copy of the MDB, since YOU
will no longer be able to change objects either. NOTE: this *does not*
affect either tables nor queries. Users still have the ability to modify
and delete these. MDEs work only for forms, reports, macros, and modules.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Armen Stein]

Save the database as an MDE file from the Tools > Database Utilities menu.
See Help for more information. However, keep a copy of the MDB, since YOU
will no longer be able to change objects either. NOTE: this *does not*
affect either tables nor queries. Users still have the ability to modify
and delete these. MDEs work only for forms, reports, macros, and modules.

Hi Sherry,

If you want to protect tables and queries too, you'll need to secure the
database using Access users and group permissions. There are many
articles about this in Microsoft support and elsewhere.

--
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/ASIN/0764559036/jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com