Liveson I have a similar but much simpler question: how do I put a password to the entire table and related queries. I have a database called MasterCompanies with a table called AllCompanies and several queries based on AllCompanies table. I would like to put a password on MasterCompanies so that no one can use it even if they see it. Can it be done? If so, how? I am a newbie so I would need a step by step instruction. Thank you
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Liveson Tumbulu Sent: Wednesday, October 12, 2005 6:54 AM To: [email protected] Subject: Re: [ms_access] password for tabs 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 Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/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/
