Tables Read-Only

[esskaykay]

I believe I may have asked this question before but…

I have a FE/BE database. Is there a way to set the tables as “read only”? I’d like the FE to be read only, but allow users to see all the tables, not just forms etc. However, if they open the BE, they would have full control.

Thanks,
SKK

 

[boblarson]

Nope, sorry but if you link the tables, they can add, delete and change whatever they want. That's why I NEVER give users the ability to see tables, or queries, directly.

 

[esskaykay]

Oh well sure would be nice. What about showing the results of a query as read only? The query could be all records?

SKK

 

[boblarson]

You might be able to if using Access security. I'm not sure though as I have been fortunate enough to not have to use it, except for one time about 10 years ago.

 

[esskaykay]

Yeah, I played with it a bit. If I open the query via a macro, I can set as RO. I'll just have a button or the users on the FE which will run the macro which will display the tables in RO mode.

Thanks again,
SKK

 

[Dennisk]

Don't forget you can hide all your tables from prying eyes!

 

[esskaykay]

Good idea...