Andrew I don't think there is a built-in Access feature to meet your requirement. However, there are several ways you can use to password-protect tab pages or forms. You can create a table that contains users and passwords and set its attribute to "hidden". Alternatively you may create a flat file containing users and passwords and save it in a certain not-too-easy-to-guess folder. In either case, write code to check permissions when a user clicks on a tab page. You may have to write extra code that allows the admin to add/edit users and passwords.
Maybe someone may come in with a better solution Regards Liveson ----- Original Message ----- From: oztitanic101 To: [email protected] Sent: Wednesday, October 12, 2005 2:46 AM Subject: [ms_access] password for tabs Hi all I am new to Access2000 I have a data base call Mcom When it start up it got to a cover form (ok) The form has 3 tabs 1. Member private detail (only teacher can go to) 2. System setup e.g. type of member, call signs (only admin can go to) 3. Radio Room operation (any one can go to) My question is. Can I set it up so there is a password for each Tab Not the database as a hole????? Andrew in OZ Yahoo! Groups Links [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
