I have a database that keeps track of vositors to our center. A student recently complained because after signing in he hit pageup and his social security was displayed.
Students enter thier number and pick a subject and class from drop downs and thenclick sign in.
Is there something I can put in the Onclick event that would not allow a new user to view the previous users info?
Thanks
Tricia
Hi,
I need a natural unique id for current and new enrollees, and I do not want to store social security numbers. If a new person enrolls, I need a way to know if they're already in our system.
I was wondering if a lookup table would work, where you switch a random autonumber for a social. If this will work, is it more secure than simply storing the socials?
Thank you!
I have a form based on a table where social security numbers are entered. I would like to enter a social security number on the form and once it's entered the first 5 digits are masked. When I go to the table I would like to see the complete social security number displayed. Is this possible? Can the control source on the form be formatted to hide the existing social security numbers as well so they don't have to be rekeyed with the new format?
Thank you in advance:cool:
G’day all.
I am posting this on more than one site but that should not matter simply because it asks for an opinion and, as such, your opinion should not be construed or even considered as an absolute answer…valued yes, absolute no.
What issues may emanate from using the US SSN, or equivalent numbers in other countries, as an identifier for unique records in a database?
Legal?
Voluntary?
Not under local database control?
And anything else you may care to mention.
Please, members from foreign countries to the US, you are welcome to add your thoughts here.
And please also, this is not about anything you may wish to take up with the Federal Court, Privy Council, High Court or whatever in the future in your country. It’s about your understanding of the situation as it stands, at the moment, in your country.
That’s about it…what do you think?
The following three links should take you to the other two sites…
(Sounds like a bit of gobldegook but you are already on one of those sites.)
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=3&Number=1001301&page=0&view=collapsed&sb=5&o=&fpart=1
http://www.access-programmers.co.uk/forums/showthread.php?t=93569
http://www.accessvba.com/forum/showthread.php?t=17057
Regards,
Chris.
I have a database for which I would like to disguise a social security number (123-45-6789) with stars (***-**-****) in my form, but only for a group of people for whom "Employee status" is "Staff". The SSN will not be entered in this particular form, only viewed to double check for all individuals who are not "Staff". Can anyone suggest how to do this? Thanks!
View 2 Replies View RelatedHow I can generate just the last 4 digits of the SSN need to be shown on the reports which are generated? For example if a SSN were: 123-45-6789 I would want the field to read ***-**-6789. I also would like to have actual row in table password protected on its own is this possible?
View 2 Replies View RelatedHI
I have a query that looks like this:
Like [Forms]![Searchaddress_form]![search_3] & "*"
The filed name is "ssn"
In a form I have an unbound field that is called "search_3" and when I type a number or more and hit enter it's supposed to look it up in the table. But it´s not working
FYI! It works whith letters. I have the same query for searchin first name and it works.
But not with numbers.
Any suggestions?
//Mikael
hello,
simple problem. how would i grab just the last six digits of a social security number?
example: 123-45-6789 to 456789
I'm guessing that I should use the Format function, but I'm not quite sure how to write it. Thanks!
G
I have a report to print that only shows the last 4 digits of the Social Security field. How can I do so for the entire list of social security #'s.
Thanks in advance.:cool:
On my form frmEmployeeDetails I have a text field that is named SSN for social security numbers. I have used the mask on it so it automatically inputs dashes. I am attempting to hide all but the last four digits of the ssn. This is on the on current event of my form.
Code:
'Hide SSN
Dim strLSSN, strSSN As String
strLSSN = Right(SSN, 4)
strSSN = ("***-**-" & strLSSN)
Me.SSN = strSSN
Good day!
Would it be possible to disable the Page Up and Page Down keyboard buttons? Also, the Up and Down arrows? If yes, how?
Thank you.
sheila
Hi Guys
I am begining to create a IT support database for my company. I have never really needed to use secuirty for the other projects that i have completed but this one is a bit different. i have used the security wizard to create the users and groups but would like to get the basis of the security correct before i go any further.
My question is how do i configure it so that users can only update or change or delete thier own entries apart from me who could alter anything. Do i begin now when i am setting up the tables or is it a bit more complex and would require checks during accessing forms etc.
Any help and advice would be great
Many Thanks
Martin
Hi,
I setup a Security. And different user,
then it creates 2 files: Account.bak, and Secured.mdw
I can open it, but it cannot be opened on another computer, why??
I already setup.
Thanks.
Well,
I am currently looking into some of the security aspects of Access, as I am still not yet sure how i'll be designing a new database program, (whether to use Delphi to link to the database or run the database through Access itself) however, I was wanting to look into the security aspect of Access itself as part of my education and decision making process. Now I have deduced (correctly?) that some of the user/group access rights are based on the NT/2k/XP User/Group permissions etc, yet I was wondering if there was a little more to it than that.
In some ways I would like the application (through access or otherwise) to initialize with a logon prompt, that would ask for username and password. The database would internally?? retain the password information for security rights. I'm not sure if i'm thinking this through correctly, so i decided to come here for a few pointers in the right direction.
I'd like to set up internal to the database a set of groups and users with different levels of security. I don't want them based on the XP user account passwords and such, but just an internal database login. This would allow, to some degree, a specific master group to add / remove users from the database, as well as control user access rights to the database internally.
More or less, I want the database itself to be self-contained with all security and access rights, instead of basing them off of some external NT based security information.
So to my actual questions:
Is this possible?
Where would I start looking to set this up?
thanks
Jaeden "Sifo Dyas" al'Raec Ruiner
Hey
When i implement user security on my access database at home with user ID's and passwords, i need to take this database and copy it into another computer at work. However, when i open my access database on other computers at work, there is no prompt for a login password or user ID.
Why is this so?
Thanks
Hey, when i set up user security at home on a database and save this database to my USB memory stick, i then take this memory stick to be open on another different computer at the internet cafe. However, when i open the database on another different computer there is no prompt for log in user names and passwords. This is not what i want.
Why is this so?
Thanks for the help
Hello everyone.
Not sure if this is possible...but I hope it is!
I have created user security with limited access for specific groups to certain forms in my database.
However, when a user attempts to open one of the restricted forms a Generic Microsoft Access Message Box opens. Am I able to customise this box so that the box Heading is not "Microsoft Access" and so that the user is not offered the option of "Help"?
Really all I want is a box that says;
"You do not have the permission to open this form."
I only want an "Ok" box as an option (not the "Help" box as well)
Any help would be extremely grateful.
Thanks in advance,
Rob
Hi, I need to add a security feature to my database. Basically I want different users to access the database with different permissions. I want a "basic user" to be only able to access the the forms with their respective default settings. I want an "admin" to obviously be able to access all the content and edit the design. I know I can do this with User-Level Security somehow, but i've tried it and it isn't working like I want it to. DOes anyone know or have any experience with this security feature.
View 10 Replies View RelatedHow do you set up user level security for your database?
View 2 Replies View RelatedI have a small problem here
I was creating a human resource database for a large firm. The number of records ranges from 5000 to 6000. Initially everything went well. My designs and development were highly appreciated. But now because of just security my DB is being rejected. The problem aroused because of the security issues. I tried using the Logging On database as presented here in the Code section of this Site. But it was completely rejected by the authorities. They wanted something like following
1.The administrator has the power to give the user special privileges like mentioned in the User level security i.e making users like read-only, backup, data entry etc
2.The administrator has the power to block any user from opening any form whenever he likes.
When I presented them with the user level security as in Ms Access they were completely lost and they find it really difficult to use. Further more the names of the forms as I have used are starting with “frm” where as they want only the simple names of each form. If I start changing my form names I would complete mess up my DB
Please advice what should I do to make the user level security easy for them to use.
Or how can I develop my own security system in which user can use my above mentioned points.
I have implemented user level security on a database and it seems to work fine. The issue is that every other database on that computer seems to have inherited the permissions. I only want these permissions to refer to that one database.
What have I done wrong?
Thanks
Niall
Hi,
I have a question.
When we create a user-level security, we can do it of the Tools-Security-> user-level security.
However,
can we use VBA code to create user-level security? Yes/No.
I just curiously want to know.
Because I just know that VBA can update the user-level security.
Please let me know, thanks.
I need to implement some type of security on my database to limit the forms/reports users can access. When implemented it will be a split database on a network. I'd like to set it up so only certain users can edit/add data on certain forms. Also I want to have more than one user be able to edit/add data at the same time. I'm confused as what I need to do to set up this type of security. I found another post on this forum by Oldsoftboss (Dave) that gave a good, working example of a database with user login screens and different user security levels. My questions are:
1. Can I use his system in place of the built-in Access security?
2 . Do I need to implement both? If I don't use or change the access rights in
Access security, won't everybody be logging in with "Admin" rights?
3. What do I need to do to let multiple users work in the database at the same
time? I've already changed the database to "shared".
4. I don't want the users being able to change the forms, queries or reports
so I'm distributing an MDE file. Is there anything else I need to do so
users can't access the "design" button?
Needless to say, this whole security thing confuses me. Any help would be appreciated.
Rod
I need to launch the database on the server as a multi user. Only one station can change the designs and major issues. But other stations have the right to add/edit/delete data. I tried that through security account and permission. It works on the admin, but not with other user login.
How can I link the access user to my server user login?
Tanks a million. :(
I want to put 2 Dbs on a network server. Below are the groups that can get to each directory.
Directory Students: Students, faculty, few staff
Directory Staff: all Staff
I will have a separate workgroup for each Db because each group of users is so different. Each Db will have all deselected user permissions and assigned groups and group permissions.
Questions:
-Could a computer programmer student get into any code in the Db in the Students directory, even tho they would not have user-level permission to do so?
-Could a student somehow affect in any way the other Db in the Staff directory?
In other words, could somebody use the Db in the Students directory to cause trouble anywhere else in our network?
Thanks
Hello guys
i want to prepare User level security for accessing database/tables/fors and reports.
So can anyone have step wise procedure? I am using wizard, but am not able to set up.
Thank very much:)