In Access 2003, I could easily make linked tables (from SQL Server) read-only, as follows:

Set con = db.Containers("Tables")
Do Until rs.EOF
Set doc = con.Documents(rs!Local_Table_Name)
For Each grp In wrkDefault.Groups
doc.UserName = grp.Name
doc.Permissions = dbSecRetrieveData

For Each use In grp.Users
doc.UserName = use.Name
doc.Permissions = dbSecRetrieveData
Next
Next
rs.MoveNext
Loop

Is there a way to get this same result from Access 2007?

Thanks!

Couldn't you make an account on SQL server that's read only then have the tables linked using that account?

Microsoft did away with workgroup security in Access 2007.

Thanks for your response. Yes, solving this on the SQL side would be the best solution, but we have a special case where locking a few non-critical linked tables on a small client app would be more flexible.