Preventing users from linking/seeing tables

[Guest]

Hello,
I have come accross an interesting request that I do not have the answer
to.

My client wishes to have a database secured so that no user will be able to
access and open the tables and see the raw data. I know i can hide the db
window and disable the special keys, but this doesnt prevent a user from
creating a new db and linking in the tables. I have also been requested to
do this without the use of SQL server or Workgroups. Is this possible? This
will become an MDE so I could hardcode 'super' users into a module that will
allow/disallow the db window.

Any suggestions? Thanks in advance!
Thanks.

 

[Rick B]

This is done with user-level security. You would create your users and take
away all their access from the tables and queries. Users would only have
access to reports and forms. These reports and forms would be based on
queries set to "run with owner's permission".

 

[Guest]

Thanks Rick. Just as a follow question because ive never worked with
workgroups...User-level security is the basis of workgroups correct? or can
this be done without workgroups?

Thanks again!
Ben

 

[Joan Wild]

Access uses a workgroup in every session, whether a database is secured or
not.

You can secure it so that users don't need a separate 'secure' workgroup;
they can use their standary system.mdw workgroup.

Again you'd remove all permissions from the tables and use the RWOP queries.

To secure it, but allow users to use their system.mdw see
http://www.jmwild.com/SecureNoLogin.htm