password to prevent editing of forms

[Guest]

I have a database that many people will be using, I don't need to protect the
database as a whole with a password. But I want to prevent users from
editing forms by creating a password. How do I password protect a from for
editing functions? Thanks in advance.

 

[Guest]

Let the users use MDE file instead of MDB, that way they wont have the
ability to change forms, reports, and modules

Check this link

http://www.microsoft.com/technet/prodtechnol/office/office2000/proddocs/opg/part4/ch18.mspx

 

[Joseph Meehan]

I have a database that many people will be using, I don't need to
protect the database as a whole with a password. But I want to
prevent users from editing forms by creating a password. How do I
password protect a from for editing functions? Thanks in advance.

MDE is likely the best way as Ofer suggested.

My question is are you using the application over a LAN? If so have you
split the database. If not you should split the database and give the users
MDE version (or if you don't care if they mess with their own forms use an
MDB.

MDE's are not editable. (The data is, just not the structure)

Split databases have one front end database for each user on their
machine that is linked to the data in a back end database on the server. It
speeds things up and causes far less problems.

 

[Guest]

Thanks. I'm not able to create a .mde because apparently we are using 2000
here. I tried to convert to 2002/2003 but that didn't work, either. I
suppose I'll just proceed with front/back end. Thanks again.

 

[Joseph Meehan]

Thanks. I'm not able to create a .mde because apparently we are
using 2000 here. I tried to convert to 2002/2003 but that didn't
work, either. I suppose I'll just proceed with front/back end.
Thanks again.

If you like, you can start a new topic about the MDE problem and maybe
someone will have an answer for you on that one.

In any case I do suggest you use the split database. Access has a
wizard to help you do the splitting. As always make a copy first.