I'm sure there probably an easy explaination for this, how do you make the main switchboard a desktop icon instead of going into the database so that all they have access to is the switchboardand the forms etc.

set the start up parameters so that the switchboard form loads on start up. Hide the database window. Then create a shortcut for the .mdb file. Then when the shortcut is clicked the db opens displaying the switchboard. If the user closes the switchboard they will not be able to access any of the db objects. You can also lock the users out of the main menu.

In MDB window click on Tools, Startup (the Startup form appear). In "Display Form/Page" field put your switchboard (form name).
Deselct "Display Database window", and OK.
You can enter in MDB window by SHIFT button.

Thanks guys