http://www.accessforums.net/ Discussion of Access security issues. en Wed, 19 Jun 2013 07:22:36 GMT vBulletin 60 http://www.accessforums.net/images/misc/rss.png http://www.accessforums.net/ http://www.accessforums.net/security/setting-up-users-passwords-permissions-35319.html Fri, 31 May 2013 20:32:04 GMT I've never done this before on a database and have limited experience with databases overall.

I want to setup custom user names and passwords (in other words, not the windows user names) for my coworkers with various levels of access to the database as follows:

Level 1 - access to reports only
Level 2 - access to reports and some forms
Level 3 - full access

I remember finding an example file a couple years ago, but could never get it to work; and I can't even find that now. When I search, all I find is how to use Windows User ID. Can anyone help me with this? ]]> Security Degs29 http://www.accessforums.net/security/setting-up-users-passwords-permissions-35319.html http://www.accessforums.net/security/32-bit-64-bit-access-problems-35317.html Fri, 31 May 2013 19:18:51 GMT I have a database that has been created with Access 32-bit but was split on a different computer that i've now realised was Access 64-bit.

My problem is the majority of the people in my organisation have 32-bit Acceess, but one or two have 64-bit.

I'm not sure of the best way to resolve this problem (ideally everyone should have had the same bit Access installed on their computers by our IT contractors, but.....)

Should I unsplit- it and re-split it on a 32-bit and get IT to install the 32-bit Access on the others that currently have 64-bit?

Thank you for any thoughts. ]]> Security pbouk http://www.accessforums.net/security/32-bit-64-bit-access-problems-35317.html http://www.accessforums.net/security/windows-login-access-2010-cant-not-converted-35255.html Wed, 29 May 2013 18:03:15 GMT first off this was posted on another part of Access Forum to which it was suggested if that answer couldnt help then to come here... I want that... first off this was posted on another part of Access Forum to which it was suggested if that answer couldnt help then to come here...

I want that when an employee logs in to their computer and brings up the database that their privilges are already assigned in this DB - by their First Name and Last Name - my question is 2 fold...

1. their log in usually consists of 2 letters and 4 numbers - i believe i will need to add this to their name in the Employee table/query i have ...correct?

2. and in doing so will need to put this somewhere in the DB for when they click it that makes it impossible for them to select another user in the DB to be able to have more control.

i went to http://www.dbforums.com/6332819-post68.html (from the other reply in the other post) and read that but not what i want as i already have the certain privileges set up in this DB - but if i have to change this please let me know and advise on how i could do this..

TIA

Stephanie ]]> Security Stephanie53 http://www.accessforums.net/security/windows-login-access-2010-cant-not-converted-35255.html http://www.accessforums.net/security/reports-security-protection-35019.html Mon, 20 May 2013 15:16:50 GMT Hi all, How and what vba code do i need please so that I can allow some users the right to edit and make changes in the database and reports and... Hi all,

How and what vba code do i need please so that I can allow some users the right to edit and make changes in the database and reports and most users "Read Only" only? Thanks in advance ]]> Security mussy http://www.accessforums.net/security/reports-security-protection-35019.html