in Access 2003 one can go to TOOLS > STARTUP and change a few settings in there - untick all of the boxes and suddenly the users are a lot more limited (they can only do what you let them).
pls somebody let me know how to do this in Access 2007.
1. Click on the "Office" button (upper letf corner).
2. Click on the "Option" button (left button in the lower part of the window).
3. In the "Access Options" window, you have several categories (on the left). What you're looking for resides mainly under the "Active Database" section.