Securing a database (1 Viewer)

I have two questions. All of my experience has been in Access 2003. My work just upgraded to 2007. I am ready to secure a database that I have now converted to a 2007.

1. Is it possible to set the db to open as read only for everyone on staff except for a few people?

2. How do I set security levels where some can view all tables and others can only view specific tables?

For example, I only want 2 people to be able to modify any data. And I don't want anyone to view the accounts receivables, but they need to see other data on the customers.

Thanks in advance.

If you have the back end on the server.. you can set the permissions for the folder on the server to do what you are asking.......


No one should be able to view the tables, but you and your team.

thanks

That will solve the first question.

I am told that 2007 no longer has the ability to make security levels. Maybe that is why I can't find them.