Force "read only" in Connection String???

[Brad]

Is it possible to force "Read Only" access (in Access 2007) when connecting
to a SQL Server database?

We are planning to use the Reporting facilities in Access 2007 and we want
to ensure that no one changes any data in the database.


Thanks,

Brad

 

[Daniel Pineault]

Create a read-only user in SQL Sever and use that account to create your
connection through Access.

Or

Make an admin connection but set your forms & queries to snapshot. Since
user's never have access to table (right!) this should work.

But I would favor the first solution.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[david]

Yes, by connecting with an account that only has read permission.

However, since you ask specifically about Access, if you delete
the primary key index from each linked table, the linked table
will be read-only.

(david)