up vote 1 down vote favorite
share [g+] share [fb]

I'd like to set up an Access (2007) project that contains queries on a database (actually in MS SQL Server 2005), but I don't want to allow any direct writing to the database.

How can I make it read-only?

link|improve this question
80% accept rate
ADP or MDB/ACCDB? – David W. Fenton May 13 '11 at 20:10
feedback

3 Answers

up vote 1 down vote accepted

This is not an Access question, but a SQL Server question. Set up roles in your SQL Server and tie them to the appropriate user groups and your users will inherit the appropriate permissions on the data according to their group membership.

link|improve this answer
Thank you! I'll try that out tomorrow. – JW. Oct 27 '09 at 4:48
feedback
up vote 1 down vote

You can hide the tables and create queries with read-only property to true.

link|improve this answer
Thanks for responding! – JW. Nov 2 '09 at 21:17
feedback
up vote -2 down vote

MS-SQL-Server Queries are represented in Acces as read-only tables when linked with ODBC. The lack of a primary key does the job.

link|improve this answer
This is not true as stated. Views can be read/write, but it depends entirely on what's in the view. And, as you say, if there's no PK it causes problems. I also recommend a timestamp field in all SQL Server tables and in all views. – David W. Fenton Jun 12 '10 at 20:11
The Question was: How to manage to get a read-only View. My Answer is short, direct and correct. You didn't specify what sort of problems may arise - so please? – Ice May 11 '11 at 12:41
I don't know why I should be answering a further question. I'd have to do research to find the answer. Surely it's as simple as setting the SQL Server permissions on the View, but your answer here IS FALSE. It is not the case that a SQL Server View is "repesented in Access as read-only." That statement is just COMPLETELY WRONG as it stands (hence the downvote). – David W. Fenton May 12 '11 at 0:37
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.