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.
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.
Linked tables with read-only permissions (or periodic import) - [
http://office.microsoft.com/en-us/access-help/import-or-link-access-to-sql-server-data-HA010341762.aspx][1] [1]:
http://office.microsoft.com/en-us/access-help/import-or-link-access-to-sql-server-data-HA010341762.aspx
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.
17 People are following this question.
