----- Original Message ----- From: Liveson Tumbulu To: [email protected] Sent: Wednesday, October 12, 2005 8:02 PM Subject: Re: [ms_access] password for tabs
Hi The suggested solution I gave Andrew involved setting a password on forms or tab pages. In your case the database can be secured by setting a database password. To do this, open the database in exclusive mode and then Tools-> Security-Set Database Password. To secure database objects like tables, forms, queries, reports, etc you need to run security wizard and set appropriate permissions for different users on different objects. There are step-by-step instructions at http://www.databasedev.co.uk/access_security.html. It must be noted that for tables and queries users are usually only prevented from changing the design while for the other objects besides changing the design they can be prevented from viewing the design as well (well, that's according to my experience). I don't think setting a password for a table is possible, even if it were it would mean the user being asked for a password every time they tried to access the table! However you can hide the database window and prevent the users from opening it through F11. To do this: open your database -> Tools -> Startup and then clear the checkboxes for "Display Database Window" and "Use Access Special Keys" (Office XP). In addition you can use code to set AllowByPassKey to False so that users cannot access the database window by pressing and holding down Shift key while opening the db. Of course clever users can still access your tables by linking them to a different db. I hope this will help you in some way. Regards Liveson ----- Original Message ----- From: LTPortella To: [email protected] Sent: Wednesday, October 12, 2005 6:20 PM Subject: RE: [ms_access] password for tabs 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 Links [Non-text portions of this message have been removed] ------------------------ 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/
