Sample Header Ad - 728x90

Microsoft Access Security

0 votes
2 answers
133 views
So I get how to connect Access to SQL Server, and I understand that the tables have to be linked, but my problem is security. If I link the tables from SQL Server into Access, then anyone who comes into the Access forms to enter data can ultimately get at the tables via the link can't they? I know that newer Access versions have no user security, but is there any way to restrict what data they see in some of the tables, or do I need to do that on the back end in SQL Server Express?
Asked by TBrown33 (1 rep)
Mar 27, 2015, 05:05 PM
Last activity: Apr 6, 2019, 05:00 PM