Hi all

Please help. one of my table is confidential data and I don't want people from opening from the table. Can I block people from opening but people who has password can only access this information.

eg. please see my enclosed attachment file and the table is cost. I don;t want people to see the data by click the table filename.

Hope someone can help me.

Search this forum for "Workgroup Security" as a way to selectively block access to some tables but not all tables in a given .MDB file. This topic is asked very often. The keywords for you are "Security" & "Workgroups" - and SEARCH really works on this forum.