Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
    
ADP or MDB/ACCDB? –  David W. Fenton May 13 '11 at 20:10

3 Answers 3

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.

share|improve this answer
    
Thank you! I'll try that out tomorrow. –  JW. Oct 27 '09 at 4:48

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

share|improve this answer
    
Thanks for responding! –  JW. Nov 2 '09 at 21:17

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.

share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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