Skip to content Skip to sidebar Skip to footer
Home / Ms Access / Ms Access 2007 / Sql Server

MS Access: Read-only Linked Tables From SQL Server?

Post a Comment
Is there any way to link tables from SQL Server to Access as read-only? There's too much data to do an import.

Solution 1:

While providing the credentials to choose the tables from your SQL database, you can configure this SQL user to have read only permissions.

  • Add tables to Access database (trough Linked tables)
  • Set SQL user (or Windows User, or Role) to "datareader" only. (in SQL Management Studio)

Post a Comment for "MS Access: Read-only Linked Tables From SQL Server?"