RE: security
Dear Fiona
Thank you for attending Access Advanced course!! I hope you enjoyed the course and benefited from it.
Please refer to the following link which provides you various security features that you have set in MS Access.
If you want to set general password to open the database then the database has to be opened in Exclusive mode. Similarly if you want to remove a password from a password protected database then again it has to be opened in Exclusive mode! This link provides you the step by step instruction.
http://www.databasedev.co.uk/database_password.html
If you are looking more from a user level security angle then please use the following link that will provide you step by step instructions (once you have understood the step 1 then press 2, 3, 4, etc...
http://databases.about.com/od/tutorials/ss/usersecurity.htm
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT