Search code examples
sql-serverms-accessms-access-2007

MS Access: read-only linked tables from SQL Server?

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

  • 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)