Pswrd Protect SQL tables in Access

[batteam]

Is it possible to password protect SQL tables in an Access database at the user level? Currently we are linking Access tables for an application from another tables only database in a shared network folder that users do not have permission to. But this is causing problems to a user of the application in a remote location. Ideally, we would like to reconfigure this process to an Access front end and SQL backend tables, not linked Access tables.

We have other databases that use SQL backend tables, but in reality, users could 'break into' the Access db and view data in the tables, unless they were somehow password protected(?). FYI: these tables contain very sensitive info on the users themselves - for mgmt eyes only.

Any help is appreciated. Thanks.

 

[Crowley16]

not sure you can do it from native access, however maybe it's possible using an adp.

in sql server, you can explicitly deny table permissions to users or groups.

--------------------
Procrastinate Now!