Linked Tables

[accessman2]

Hi,

How can I prevent the user to link tables from SQL Server?

In SQL Server, I give out read and insert permission on specific table in SQL Server, I create one MS Access database which linked tables, I hided the database windows, create the forms. I want the user to input/read the data via the forms.

However, if the user create the new MS Access file, and then use ODBC to link tables himself if he knows server name and database name. He can see and input the data into the table directly.

So, how can I prevent the user to link tables to their files?

 

[FoFa]

Create an Application ID on the SQL Server. Use that to link the tables (do not give the individual users access to the SQL server). Make sure none of them know the application userid/password to access the SQL Server.