Protecting the Design of Form

[flygal5]

I have created a database (Access 2003). I am putting this on a network's
shared drive but would like to prevent others from modifying the design. Is
there a way to do this without being too complicated with permissions?

Thanks for your help.

 

[tina]

1) split your database: backend (tables only) on the server, and frontend
(all other objects) on each user's PC. for more information, see
http://www.granite.ab.ca/access/splitapp/index.htm.

2) before deploying the frontend database to the users, convert it to a .mde
file (make sure you keep the master frontend db as a .mdb file, for future
changes). in a .mde file, forms, reports, and modules are safe from
tampering - though the tables (linked from the backend), queries, and macros
are not.

hth