Protect Design View, but Allow users to populate fields.

[Jose]

Hi I am creating a volunteer database (MS Access 2007) with contact and
volunteering history information

(realted thread:
https://www.microsoft.com/office/co...ffice-access&lang=en&cr=US&sloc=en-us&m=1&p=1 ).

My database is finished but I need to send it to different people for them
to fill up around 300 records for volunteers.
The work is supposed to be divided such that one person can input about 50
records, and then pass the database into another person and repeat the
process until all records have been entered. I want to protect the design of
the database so that none of the other users can edit any of the database
characteristics.
The only thing they should be able to do is add info into a form. I have
been reading the access help and forums but so far I haven't found anything
that can help me because I am new to access.

Note: I have read about splitting the database into FE and BE but I am not
sure I have the resources to do it that way (need a server?)
Any help on this would be greatly appreciated!

Thank you!

 

[John W. Vinson]

My database is finished but I need to send it to different people for them
to fill up around 300 records for volunteers.
The work is supposed to be divided such that one person can input about 50
records, and then pass the database into another person and repeat the
process until all records have been entered. I want to protect the design of
the database so that none of the other users can edit any of the database
characteristics.

Save the database as an .accde ("compiled") database. This turns off all
design tools. You obviously need to keep the .accdb yourself.

The only thing they should be able to do is add info into a form. I have
been reading the access help and forums but so far I haven't found anything
that can help me because I am new to access.

Note: I have read about splitting the database into FE and BE but I am not
sure I have the resources to do it that way (need a server?)
Any help on this would be greatly appreciated!

No server is needed, and no special tools. See
http://www.granite.ab.ca/access/splitapp.htm
for a thorough discussion.