RE: Permanently hide table
- From: Chris O''Neill <ChrisONeill@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 22 Aug 2008 15:25:01 -0700
"Boon" wrote:
Hello,
I am creating a standalone Access application. I save the application as
..mde. How can I hide the table so that people will not see them. I want to
permanently hide them. Is there a way to lock, or encrypt the table? To be
clearer, I want users just click on the form and have no access to tables.
I'm not really sure what you're trying to do, but you can "hide" a table in
a database by giving at name starting with "Usys" (e.g. UsysMyTable). Then,
it won't show up in the Database window. You can also encrypt the database
(Tools --> Security --> Encrypt/Decrypt Database). Finally, you can setup
Access security so that only you (or anyone else you choose) will have access
to the table(s). This includes granting privileges to open form(s) but deny
access to tables. For more info on how to setup Access security, see the FAQ
here:
http://support.microsoft.com/kb/207793
Thanks a bunch
You're welcome. If you provide more specific details of what you're trying
to do, you'll probably get more detailed help. in the meantime, I hope this
helps...
Regards, Chris
.
- Follow-Ups:
- Re: Permanently hide table
- From: Boon
- Re: Permanently hide table
- Prev by Date: Problem using Access in Active Directory
- Next by Date: Re: Disable Security Warning in Access Runtime
- Previous by thread: Problem using Access in Active Directory
- Next by thread: Re: Permanently hide table
- Index(es):
Relevant Pages
|
