I set up users and permissions for my DB. This DB will be shared through out the office. Why is it that when I open the DB from a different computer, the users and permissions are gone, the sign in with password is gone?
No, you're not dumb. What you need to realize is that Access security consists of a few things. One of them is that only some of the security settings for the database are stored within the database itself. Permissions are stored within the database. However, the users and groups that you've set up are stored in a separate file with an .mdw extension. It's called the workgroup information file.
You probably didn't know you were really working with 2 separate files for security because by default, Access security is always on, and every copy of Access loads the same default workgroup information file - unless you create a different one.
OK, so what does this mean for you? Well, you developed the db on a particular machine. If you're able to log onto Access at that machine and open the db with the permissions you've assigned, then it must be pointing at the proper workgroup information (mdw) file. Just find the path to that workgroup information file. The easiest way is to do a search of your local hard drive and look for files with an mdw extension. I doubt you'll have more than 1. That mdw file must be available to everyone who needs to access your database. The best location is on a shared LAN drive.
Then at each machine, you need to have those users load up your mdw file, not their default mdw file. Since the user might not want to always use the security settings you set up all the time, only when they use your db, set up an icon for them, and point it at the proper mdw file. That way, they'll only use those security settings for that Access session. The icon target line will look something like:
