Hey y'all!

Here's hoping someone can help me out. So I'm working with Access 2007, and have just finished creating a program for someone (has tables, macros, forms, e.t.c). Now as many people will be using this little program, I created different user accounts at different levels with respective rights. i.e. admins and regular users, with only the former having rights to making changes.

My problem now is that I have just realized that these user accounts are only relative to my computer, and once I send the files to someone else, they are able to make all the changes they want without ever being prompted for a password.

So if you have experience working with Access, can you tell me how to create accounts that are not only valid on my computer?

Thanks!
S.

As long as you understand the limitations of MS Access. This link should get you started. Bottom line, you need to create your user groups and any other security/protection via Ms Access itself.

http://www.msaccessblog..com/2006/11/create-msaccess-user-account.html