I have a Microsoft Access database using linked tables to SQL Server.
How can I ensure that the database user cannot open the tables? For example, if I have 2 users, each with their own subset of data, how can I prevent them from opening Access, and just opening the tables from the left-margin. I have experimented with Hidden Objects, etc, but this is not entirely fool-proof.
Do I need to do something with SQL Server?