Yes I tried to put my database in *. Accde mode but it allows the user to see the forms in creation mode, so they can change them.
Did you just rename the file? You need to actually create the .accde through the Access interface. The users CANNOT get into design view for forms/reports/modules once you do that. Try again. Also make sure you don't lose the .accdb because you cannot go back. If you need to make changes, you'll need to make them to the .accdb and then recreate the .accde.
I reread your initial post and it sounds like you have all the users sharing the same database. That makes for an unstable environment. You need to split the database into an FE and BE if you haven't done so already and distribute the FE to each user so they have their own personal copy on their local hard drive.
smartascii - giving users the Access runtime doesn't do anything to protect the database. They can still open it with the full version if they have it or simply copy the file and take it home to play with. Granted, the .accde doesn't give much protection but it does give some.
After creating the .accde, you can rename it to .accdr. That tells Access to pretend to be the runtime engine so the user will not under any conditions be able to get to design view on anything which on the surface is exactly what you want. However, if the user reads these forums, he will know that he can simply rename the file back to .accde and get in and mess with the queries and macros. He'll have to open the BE to mess with the tables.