Preventing users from seeing raw data

I have a split database which has some rudimentary security in place which
prevents unauthorised users from double-clicking the data file and seeing
anything worthwhile. If they do this a popup window appears telling them
they have to use the front-end database to see the data.

The problem with this is they can still link the back end data tables into
an application they have control over and see the data that way.

Is there any way to stop users from linking to tables?

Thanks

re: Preventing users from seeing raw data

An easy solution is putting a database password on the backend. Undo
the links first and relink the tables after you have set the password.

re: Preventing users from seeing raw data

You would have to implement Access User Level Security and allow data access
ONLY through Run With Owner Permission (RWOP) queries, then remove all
permissions from the tables and the database containing the tables. The
Access SEcurity FAQ has some info on this;

http://support.microsoft.com/Default...#_Toc493299687

Topics num 13, 14 and 18 would be a good place to start.

"Trevor Williams" <trevor@NOSPAM.co.uk> wrote in message
news:42493c73$0$26486$ed2e19e4@ptn-nntp-reader04.plus.net...[color=blue]
>I have a split database which has some rudimentary security in place which
> prevents unauthorised users from double-clicking the data file and seeing
> anything worthwhile. If they do this a popup window appears telling them
> they have to use the front-end database to see the data.
>
> The problem with this is they can still link the back end data tables into
> an application they have control over and see the data that way.
>
> Is there any way to stop users from linking to tables?
>
> Thanks
>
>[/color]

re: Preventing users from seeing raw data

"Rog" <delahayerc@state.gov> schreef in bericht news:1112098870.238156.104710@g14g2000cwa.googlegr oups.com...[color=blue]
> An easy solution is putting a database password on the backend. Undo
> the links first and relink the tables after you have set the password.[/color]

Db-password is no security at all. Crack can easily be found online.

Best you can do IMO is setup Acecss-security. This is not easy !
Lock all tables and use RWOP-query's. Check out the security-faq.
http://support.microsoft.com/support.../Q165/0/09.asp

Unfortunately even Access-security is *not* bullet-proof ....


Why do you care when users can see raw-data, or can link to the data ?
It's *their* data after all ...

--
Hope this helps
Arno R

re: Preventing users from seeing raw data

Per Trevor Williams:[color=blue]
>
>Is there any way to stop users from linking to tables?[/color]

SQL Server and views/stored procedures instead of tables.
--
PeteCresswell