|
----- Original Message -----
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 -----
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: ms_access@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf
Of Liveson Tumbulu
Sent:
Wednesday, October 12, 2005 6:54 AM
To: ms_access@yahoogroups.com
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: ms_access@yahoogroups.com
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/
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
|
