Microsoft Access - how to protect the queries and tables in access, not the database. Need it on urgent basis

Asked By Praveen Chennupati on 02-Apr-13 09:17 AM
Hi,

I have a database. I would like to share this database to a larger group. I do not want them to access to queries or tables, instead they can access the required data through forms only.

Can you please let me know how can i protect the queries/tables, even its better if they cannot see them at all.
Robbe Morris replied to Praveen Chennupati on 02-Apr-13 09:23 AM
Have you gone through this?

http://www.techrepublic.com/blog/10things/10-tips-for-securing-a-microsoft-access-database/552
Praveen Chennupati replied to Robbe Morris on 02-Apr-13 09:41 AM
these are still giving the user to access queries/tables through different options. I would like to set up a password kind of thing for all tables and queries so that they cannot decode it.
Robbe Morris replied to Praveen Chennupati on 02-Apr-13 09:47 AM
Points #4 and #8 seemed to be on target.
Praveen Chennupati replied to Robbe Morris on 02-Apr-13 10:17 AM
point #8 is a password to database as a whole. If i put password to it, they cant access the database itself. I want the user to access database, but should not have access to queries and tables.

Robbe Morris replied to Praveen Chennupati on 02-Apr-13 10:41 AM
Which is where the point on splitting the front end into its own database comes in.