Access 2002 SP 2 "lock database from users' editing?"

[Jackson Vanderlinden]

I have a question regarding Access 2002 SP 2. I have spent a lot of time
making a nice database for people to use and want to make sure that no one
can edit the internal functions that I have created, as well as any of the
visual components that I have built in. Is there a way to allow people to
enter their data without the possibility of them editing/changing the actual
architecture of the database? Any help is appreciated.

Thank You,

J. Vanderlinden

 

[Gary Miller]

Jackson,

If you convert your database to an '.mde', no one will be
able to see any code or do any design changes, but will
retain full data entry, editing and reporting ability. Make
sure to do this to a copy and to keep your original master
an '.mdb' or you will no longer be able to do any design
changes either.

If you do this, make sure that you have good error handling
routines in place as any unhandled errors can just shut down
the program with no error messages at all.

Gary Miller