CODEWITHSUNDEEP
sql-serverms-accessms-access-2007
Absinthe
Absinthe

Reputation: 3391

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.

Upvotes: 2

Views: 3493

Answers (1)

Davy M
Davy M

Reputation: 76

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)

Upvotes: 6

Related Questions