Home » Questions » Computers [ Ask a new question ]

Is there a way to restrict direct write access to the database in Microsoft Access 2007?

Is there a way to restrict direct write access to the database in Microsoft Access 2007?

I'd like to set up an Access (2007) project that contains queries on a database (actually in MS SQL Server 2005), but I don't want to allow any direct writing to the database.

Asked by: Guest | Views: 23
Total answers/comments: 2
Guest [Entry]

This is not an Access question, but a SQL Server question. Set up roles in your SQL Server and tie them to the appropriate user groups and your users will inherit the appropriate permissions on the data according to their group membership.
Guest [Entry]

MS-SQL-Server Queries are represented in Acces as read-only tables when linked with ODBC. The lack of a primary key does the job.