By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,084 Members | 1,969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,084 IT Pros & Developers. It's quick & easy.

Hide Table, Query for use viewing in MS Access

P: 1
Hi! Currently we need to give user the mde file to run the report. But as mde just can hide form, marco, modules only. Does there have anyway hide the table and query for the user to view the design?

Btw our query also got append, update, delete query. Got try to give the user right. But user still able to see/view the design of the query and table.

Please help. Thanks
Oct 19 '06 #1
Share this Question
Share on Google+
3 Replies


100+
P: 179
What?????????????
Oct 19 '06 #2

NeoPa
Expert Mod 15k+
P: 31,429
Your question is a little unclear ;-)
But you might find what you're looking for if, after opening a db, you explore the Security section under the Tools menu.
Good luck.
Oct 19 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
If the question you're asking is how to hide the tables and queries from the user?

Go to Tools - Startup menu and unclick the 'Display Database Window' before creating the mde.


Hi! Currently we need to give user the mde file to run the report. But as mde just can hide form, marco, modules only. Does there have anyway hide the table and query for the user to view the design?

Btw our query also got append, update, delete query. Got try to give the user right. But user still able to see/view the design of the query and table.

Please help. Thanks
Oct 20 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.