Question Access 2003 Security issues

[MikeDeal]

Hi, I am running a database to record safeguarding issues in a high school. I have several users using the database and there are certain parts that I need to keep from prying eyes. At the moment, I do this by having to seperate databases with different passwords and I update the public table by copying it and placing it in my 'secure' database each evening so that I can run reports.

Is there an easier way of doing this? Can I password protect certain tables?

Thanks, Mike