-
January 20th, 2006, 02:33 PM
#1
Read Only Tables in MS-Access
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
-
January 20th, 2006, 03:17 PM
#2
Re: Read Only Tables in MS-Access
Well, I am delighted for the knowledge you passed on. I cannot thank you enough .
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.
Can you help me with my homework assignment?, Before you post!, Use code tags, How to post!, Codeguru technical FAQs, C++ FAQ Lite, Stroustrup: C++ Style and Technique FAQ, Guru of the Week, Comeau C and C++ FAQs, Comeau C++ Templates FAQs, CUJ @ DDJ, Spam threshold
My Blogs : Learning C++ is fun | Abnegator's reflections
Open Threads : C++ Aha! Moments | Nature of work in C++?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|