Securing Data

[Guest]

Hello,

I have a general question regarding securing my database. Right now I have
all my tables hidden as well as everything possible via the Start Menu found
under Tools - Options. Then I build users switchboards with all the macros
set as Read Only.

However, it has come to my attention a user has built spreadsheets that link
to my data in my tables even though they are hidden. If I build user work
groups can I eliminate this nuissance? I have no reason to trust this
individual so if any other options are available to me, please let me know.

 

[Guest]

Hi OShea,

If you secure your database using the Access User and Group security (wizard
or otherwise) you can prevent unauthorised updates to your data - even
through third party programs.

Damian.

 

[Guest]

Thanks for that. But I am also concerned about them viewing data via programs
like Excel. Although no legal information is contained within, we still like
to keep the Employee personal info private.

 

[Guest]

Hi again,

I'm pretty sure that if you remove the users rights to open the back end
file (as opposed to removing their rights to the tables) you can stop them
directly linking to the back end. Of course, they could then link via the
front end if they were cluey enough... I guess at the end of the day people
with access to the database have access to all these details anyway...

Damian.

 

[punjab_tom]

if you used SQL Server and Access Data Projects; it is EASY to set up
row-level security.

a) create a view, filtered for the current user
b) put check_option in the view DDL
c) remove permissions for end users to see the table


and presto-chango-- you're probably REALLY close to what you need to
do.
and it doesn't really involve _ANY_ sql; it is all drag and drop just
like Access-- but then you don't have to screw around with linked
tables or connection strings, DSNs--- none of that crap is necessary
when you just use Access Data Projects

 

[Guest]

Crikey. Pretty much what I feared though.

Hi again,

I'm pretty sure that if you remove the users rights to open the back end
file (as opposed to removing their rights to the tables) you can stop them
directly linking to the back end. Of course, they could then link via the
front end if they were cluey enough... I guess at the end of the day people
with access to the database have access to all these details anyway...

Damian.