question

emil87b avatar image
emil87b asked

how to represent data from sql server 2008 in mdb access DB

Hi, some time ago we started moving database on one of our products from access db to sql server 2008 r2 express. However our customers developed a way of extracting data already from access database and we don't want to make their life difficult so im just looking for ideas of representing data from SQL Server in access database in a way that would give customer visibility, but prevent in doing any changes.
securityaccessviewslinked server
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

This web site runs on voting. Please indicate all helpful answers by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate this by clicking on the check mark next to that answer.
0 Likes 0 ·
KenJ avatar image
KenJ answered
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

iainrobertson avatar image
iainrobertson answered
You can link SQL Server tables via ODBC: 2007: http://office.microsoft.com/en-gb/access-help/import-or-link-to-sql-server-data-HA010200494.aspx#BM2 2010: http://office.microsoft.com/en-gb/access-help/import-or-link-access-to-sql-server-data-HA010341762.aspx#BM4 In order to restrict access (no pun intended) to the data, you should connect the database using a specific SQL Server account with select permissions only on the objects that you need to allow access to.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.