Read Only Tables in MS-Access

[daniel99]

I have some power users that need to be able to do ad-hoc queries on SQL tables from MS-Access. I want them to be able to query without risk of editing any data. I googled around and couldn't find anything. Here's a way I've found to do it.

1) Attach the SQL tables in the normal way.
2) Create a query against the table(s).
3) Under Query Properties, set the Recordset Type to Snapshot.
4) Hide the original tables from them by right-mouse clicking on the table and setting the Attribute to Hidden.

That's it. They can play all they want with their queries without risk of editing data.

Daniel

[exterminator]

Well, I am delighted for the knowledge you passed on. I cannot thank you enough :rolleyes: .

Jokes apart - views are good in such situations. But I am too lazy right now to any research for access if it supports them or what you said is actually a view itself. But what is you question? Regards.