Secured Tables

[Lissa]

Hello All,
I have implemented Access security and it seems to be working or so I thought
I need to hide a few tables from users but some reports require access to the tables - which forced me to grant read access to the tables... which then lets users read the sensitive data. This is not good... How do you get around that issue? I'm confused...

(My DB is split into a FE/BE)

Thanks,
Lissa

 

[boblarson]

some reports require access to the tables

What, exactly, do you mean by this statement? Do you mean the users need to open tables directly?

 

[Lissa]

Hi Bob -

What I meant is that the report contains a subreport which calls a query that queries one of the tables I was wanting to hide from the users. From what I have tried so far, unless I grant that particular group 'Read Data' access, the data on the subreport won't show up on the main report.

Lissa

 

[boblarson]

Yes, they would have to have read access to it, but you should be able to use code to limit the user group so that they can't get to the database window to view the tables. You could also limit the backend with code in an autoexec macro that would check their userid and if it wasn't a member of a particular group, it would automatically close.

I don't like putting code into the backend because it makes it much more susceptible to corruption, but if you absolutely have to, that is one way you could do it.

 

[Lissa]

I guess I'll try disabling the database window option with code. I was just hoping there would be a simpler way to do it.
Thanks Bob

Lissa

 

[boblarson]

Just make sure to make a copy before you do it and remember to not lock yourself out.