Hey I'm making a database for a school project, and basically when you open up the database file I want it to ask for a username and password. And some people get full control over it (they can edit text and numbers, etc) and others can only view it.

For example if I login in as "Admin" I want to be able to edit everything, but if I login as "John" I want to make it so you can only view stuff.



While we are on the security topic.. is there anyways I can restrict the number of times someone can search the database? I don't want someone searching like 100 times and just collecting info. So if the database gets searched like 20 times in under 5 minutes, can you make it cut them off?

Help is much appreciated!! Thanks

Also I've been reading posts and forums about this for a couple hours, but I really havent found any good step by step guides on how to do it.

Go to the help menu and search for security. In A2003 there is a section called "Help protect an Access database and its objects with user-level security (MDB)" You should find this or something similar with step-by-step instructions.

As for searching I think you would have to add a Database Property that got incremented after each search using code but It would have to be user specific.

__________________
Regards
JD

Software matters - Bespoke Access Database Design and Development

Please go through the link below step by step from the beginning.
http://www.databasedev.co.uk/distribute_secure_app.html