Re: How to use paswords for 2nd and 3rd page
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 26 Dec 2007 21:03:44 -0700
On Wed, 26 Dec 2007 19:16:00 -0800, Frank Situmorang <hfsitumo2001@xxxxxxxxx>
wrote:
hello,.
On my church membership forms I created a tab control
1. 1st page is a general information of the members
2. 2nd and 3rd page is a confidential info of a member
My question is, since the database will be used by many departments in my
database, how can I make that every time they click the 2nd and 3rd tabs,
they asked for the pasword. Or is there any way that htis 2 tabs can be
visible to only chruch clerck and church elder.
Thanks in advance
A Tab Control is JUST a way to manage screen real estate. It's not really
suitable for managing security!
Have you set up Access workgroup security on this database? (If it's in 2007
you haven't... it's been disabled). If so you could set up security on your
tables, queries and forms so that the confidential information is visible only
to the authorized people; you may need to have Subforms on the tab pages to
display that information, and you'll certainly need to pull the information
out of the member table into a confidential-information table, probably in a
one to one relationship to the main table.
Even at that, workgroup security isn't as good as St. Peter's golden gate
logbook... it can be cracked if someone is determined and willing to do some
google searches.
John W. Vinson [MVP]
.
- Prev by Date: RE: Conditional Formatting Access 07
- Next by Date: Re: What is controltip text? Looking for a field to store some text
- Previous by thread: RE: Junction Table IDs via a form
- Next by thread: Re: How to use paswords for 2nd and 3rd page
- Index(es):
Relevant Pages
|
