General - Lock Database

How do I lock the database so that the user can't change or see anything except the forms they need, and yet I can still get in and change things if I need to? I went to the Access Options window and disabled everything, but then couldn't figure out how to enable it again so I could change what I needed to.

There really isn't a simple way to do that. There are several options that are sometimes used to approach that. Prior to Access2007, one way would be to set up User Level Security, giving yourself a password that gives you full privileges, but giving everybody else a password that limits their access to what they need. Unfortunately, Microsoft decided to remove User Level Security from Access 2007. Another way is to compile the .mdb into an .mde file (under Tools menu), but then you would have to keep your own copy of the .mdb so that you could revise it and recompile a new .mde when necessary. Other than the previous options, about all you can do is use several means to "hide" everything but what the users need; however, anyone knowledgeable in Access can defeat those measures. But if you only need to keep naive users from accidentally getting into things they shouldn't, the latter can be useful.

I know how to "hide" the things I need to, but how do I get them to show up again for me? How do I disable the hide?

One of the main object to hide in your db is the db window. You could hide it by setting the "startup option" to hide the window during start up. You could by pass this hide option by depressing the "shift" key when you open the db. Like Don said in the previous post, anyone knowing about access would easily defeat this option. However, You could further secure your db by disabling the "bypasskey" which would not allow anyone to use the shift key to by pass the start up commands. There is a ultility I posted here sometime ago (got it from another help forum) which would let you disable/enable the bypasskey. Once you have prevented your user from accessing the db window, you would set up your db with some type of menu, switchboard, etc to allow your user access only to the items you intended for them.