Modules & VBA :: Login Form And Users Permissions
Mar 30, 2014
I have been searching for info with users & permission levels. I have ready a lot about ULS (User Level Security) which doesnt seem to be my answer as I do not have admin rights and I believe it is not suitable with Access 2010.
Basically I have an 2010 Access database which is used by my department as a project management tool. It has various tables, forms, queries & reports, I have created a table with user names & passwords and a login form. So when the databases opens the login form is launched & the users selects their user name & enters their password, then the main menu is shown.
Everything works really well, but as the moment there is no difference between all the users. All I want to do is to be able to make one of the Logins read only, ie if the Reviewer is logged in they can see & read every form and run every report but they can not make any edits.
View Replies
ADVERTISEMENT
Apr 20, 2005
I have built a login form which shows or hides all tool bars depending on the
user name and password. Can I also control the other permissons like being
able to edit forms and tables? I know I can do this using the MS Access
built in functionality, but can I do it programatically from my user login
screen.
I set the tool bar visibility, close the login form and open the main
switchboard using the "on click" button of my login form. Can the above
permissions controls be done here as well?
Thanks in advance.
Peter
View 1 Replies
View Related
Jul 8, 2014
I need to separate Users and admin on login so that the admin can go to admin form and users to specific form using vba access. Here is my login code
Private Sub cmdLogin_Click()
'Check to see if data is entered into the password box
If IsNull(Me.cboUserName) Or Me.cboUserName = "" Then
MsgBox "You must enter a Password.", vbOKOnly, "Required Data"
Me.cboUserName.SetFocus
[Code] .....
View 8 Replies
View Related
Aug 11, 2015
I have my application split, BE and FE. This is a form with a subform.For both I have the properties set to
Data Entry NO
Allow additions NO
Allow Deletions NO
Allow Edits NO
anyone person can open the form, but when a second person tries to open the same form we get the standard, locked by user or user does not have permission.If user 1 logs out then user 2 can get in. So it seems not a permission issue but some setting I have wrong. maybe at the query or table level?
View 6 Replies
View Related
Jun 12, 2006
We use an Oracle base software called Trapeze and Microsoft Access sometime used as a front hand to access the Trapeze oracle tables.
Since a user has to be created in Oracle, with update, delete, read, write, append rights, for Trapeze to work correctly
Is there a way for me (, even though the user has update, delete, read, write and append rights via oracle) to limit them to "read" only on the table and not update when they access the database through MS Access to create raports? I would like to allow them to create reports by linking to Oracle tables, but I don't want them to be able to update or delete or change the data in those tables.
They only way I want them to change the data has to be through the Trapeze GUI front hand application.
Any suggestions is greatly appreciated.
Thank you.
View 2 Replies
View Related
Jan 25, 2007
Basically I have a secured split database. Each user has a copy of the FE on their local drive and the BE is on the server. I have 2 main user groups: FinanceUsers and purchasingUsers
Both groups of users edit data directly in the invoice table ( believe me it was not my idea - I am slowly improving it - enforcing relational integrity and fixing the table and field names and creating forms).
When a Finance user edits data in the Invoice table and tries to close it they get a message asking if they wish to save the design changes if they have changed col widths or anything. They just click no and the table closes. (Is there any way to prevent this message coming up? They do not have modify design permission in any case.)
The main problem is that when a purchasing user edits data in the Invoice table a dialog pops up asking if they wish to save the table as a form, data access page or query. (They do not get the message box asking if they wish to save design changes at all)
If the user clicks cancel the window does not close. If they choose 'form' and type a name for the new form for instance it will not save it (presumable because they do not have 'Open Exclusive' permission). So they cannot close the Invoice table at all.
Both groups have the same permissions on the Invoice table: Read Definition, Read Data, Insert Data, Update Data, Delete Data.
The only difference between their permissions is that Finance users have 'Open Exclusive' permission on the database and Purchasing users do not. This is the same in the BE and FE. I would prefer that no-one had open-exclusive permission really.
It is really odd - It only happens with the tables. Any ideas what is causing it?
View 4 Replies
View Related
Jan 10, 2008
I am receiving an unexpected message when a user tries to launch a form that the user does not have permission for via the Access Security-Permissions setting that I have configured.
I am trying to set my Access db up so that Guest users can only access 2 Forms - the Switchboard and the Main form. There is a Maintenance Form and I don't want Guest users having access to it.
I have configured Security and created a Group named Guestgrp. I have also created a user named Guest that is assigned to the Users and Guestgrp groups.
The Users group is currently set up with NO permission for any form.
Here are the Guestgrp permissions for the forms, db and tables
The following forms have Open/Run and Read Design permission
Switchboard
MainForm
The following forms have NO Permissions selected
Maintenance Form
The database permission is set to Open/Run
Table permissions
The Guest group has Read Design and Read Data permission for all tables
so here is what happens...............
My Guest user can log in and launch the Switchboard form and can launch the Main Form from the switchboard.
BUT......................
When my Guest user clicks on the Switchboard button for the Maintenance Form, the following message pops up:
There was an error executing the command.
Is this the normal way for Access to indicate that the user does NOT have permission to access a form? I am guessing/hoping that it isn't and if configured properly there would be a message indicating that permission is denied or something of that nature.
If anyone has any comments, suggestions on the error in my ways, I appreciate any comments/suggestions/clarifications.
Thanks
View 4 Replies
View Related
Nov 22, 2013
I have been using a A2003 file through A2007 to be able to use user security.We are now in A2010 and the users and permissions component is not showing in the Administrator area as it did in A2007, although the security is still functioning. How do I get access to Users and Permissions in A2010?
View 1 Replies
View Related
May 7, 2006
Dear All,
Hello,
In my MS-Access have many Tables,Reports,Forms.Want give read,write permitions to admins’ and ‘users’ have only read permitions for reports ,Pls help me how to create permitions
for admins’ and ‘users’ by login.
Thanks
Manish
View 1 Replies
View Related
Jun 27, 2013
I have a voting application that need to limit users to only be able to login once to vote.Firstly how do you record in a table when a user login and at the login form how do you check to see if the user have logged in previously.
I have a login form with a username and password fields that work perfectly.
View 2 Replies
View Related
Apr 28, 2005
Hi guys,
I need help in setting up a login page which would redirect users to their specific directory, file, or URL.
I'm able to create the login page without any problem but i'm unsure what exactly i need to do afterwards to get this to work.
can someone, anyone please help
your help would be much appreciated.
please mail me with any information you might have the1@studio9.shacknet.nu
thanks in advance.
View 1 Replies
View Related
Apr 17, 2015
I have a ms access application in Front End and linked tables to sql server 2008 r2 in back end.. every time I open my application the linked tables ask to me for the user and password of the sql server user of the odbc conection. I want to connect to my sql database without login every time the user open the application, I know that can be possible if I start session from vba code...
View 2 Replies
View Related
Jun 17, 2013
I have access 2010, I currently have a database in place and operational. What I am wondering is there a way to have a form come up whenever someone opens access and asks for a password and login name. Also I would like to have a 2 tier system. One for Admins and the other for users with limited access.
Is this even possible to accomplish?
View 2 Replies
View Related
Mar 12, 2014
If the database sits dormant or unused for 10 minutes the login window needs to reappear for a possible new user.
View 1 Replies
View Related
Nov 27, 2014
I have a table called 'Klanten' which contains the rows 'password' and 'login' (and several rows not needed for this form)
So I'm trying to make a login form which first checks if something is entered (this part of the code seems to work).
Private Sub Knop13_Click()
'Check to see if data is entered into Username
If IsNull(Me.Username) Or Me.Username = "" Then
MsgBox "gelieve een login in te voeren.", vbOKOnly, "Required Data"
Me.Username.SetFocus
[Code] ....
But from then on i seem to have some issues.. The part of the code underneath seems to only work for the first 'login' and 'paswoord' in my table called "Klanten".
-Username is the name for the field where they enter their 'login'.
-Password is the name for the field where they enter their 'paswoord'
If Username.Value <> DLookup("[login]", "Klanten", "[Username]='" & Username & "'") Then
MsgBox "Invalid Username. Please try again.", vbOKOnly, "Invalid Entry!"
Exit Sub
End If
If Password.Value <> DLookup("[wachtwoord]", "Klanten", "[Password]='" & Password & "'") Then
MsgBox "Invalid Password. Please try again.", vbOKOnly, "Invalid Entry!"
Exit Sub
End If
Then as last part i would like to goto another form called 'Mainmenu' if both the Login and the Paswoord is correctly entered in the fields Username and Password. Here i have the most issues as this doesn't seem to do anything at the moment
If Password.Value = DLookup("[wachtwoord]", "Klanten", "[Username]='" & Username & "'") And Username.Value <> DLookup("[login]", "Klanten", "[Password]='" & Password & "'") Then DoCmd.OpenForm "Mainmenu"
End Sub
View 1 Replies
View Related
Jun 23, 2015
I am doing a login form for my database using online references and videos.
Below is the code for my login form.
Private Sub Form_Load()
Dim Security As Integer
Me.txtUser = Environ("USERNAME")
If IsNull(DLookup("UserSecurity", "Userslist_table", "[UserLogin]='" & Me.txtUser & "'")) Then
MsgBox "No Usersecurity set up for this user. please contact the Admin", vbOKOnly, "Login info"
[Code] ....
End Subi am facing problem for run-time error type mismatch '13': i have listed below field names which is used in above coding.
UserSecurity_table
[SecurityID] is Autonumber field
[SecurityLevel] is Text field
Userlist_table
[UserID] is autonumber field
[Username] is text field
[Userlogin] is text field
[Usersecurity] is text field
[Password] is text field
View 13 Replies
View Related
Feb 21, 2015
I have recently started a project and become stuck already. I have a login form created that works (code below). What i want to do is allow access to the users of 1-7 in table (level of access) which will determine which page they view after logging in. IE if the have Access in table "Users" as "1" then when they log in the will see a form thats called L1. Same with 2,3,4,5,6 & 7.
Code:
Private Sub LoginButton_Click()
If IsNull(Me.LoginUsernameText) Then
MsgBox "Please Enter Username", vbInformation, "Username Required"
[Code].....
View 5 Replies
View Related
Jun 18, 2013
I am looking to lock my database until the user puts in the correct credentials.
I have already put the form on Pop Up and Modal. They can still select the "X" in the top right of the window.
View 1 Replies
View Related
Jul 11, 2014
I'm new to Access and I'm using Access 2010.
I would like to be able to click a button on a form in my data base and login to a website using my username and password.
The manual login, requires two clicks after username and password, "Login" and "Click to continue"
I have tried many solutions found on the internet, none work for me. One forum reply was to send me a link to another site and it was for Excel. Is the code the same? Didn't work anyway.
From the website I want to login to, I have copied the code into a Word doc from the "inspect element" to work out the names of the fields I'm trying to put my username and password into. (see attached)
I would also like to be able to use Google Chrome as my web browser if possible?
View 8 Replies
View Related
Oct 8, 2013
Can i make an html of login form, whose data is saved in access as back end. I am curious to know. but of course simultaneous saving is considered yes in here...
View 1 Replies
View Related
Feb 25, 2014
I have been trying to create a login form that allows the user to change his/her temporary password logging it to the proper table along with timestamp and who done it info.But, after spending the morning trying to find the proper syntax I am flummoxed.
I can get everything to work accept the update of the fields. I can get the command to work (writes to the location) but it does the pop-up what is the parameter thing when it works. I have all the information just need to get it in so the command recognizes it.
DoCmd.SetWarnings False
DoCmd.RunSQL "UPDATE lut_TeamList SET Pass = txt_Password.value WHERE TeamListID = Me.cbo_UserName.Value"
DoCmd.RunSQL "UPDATE lut_TeamList SET UpdatedBy = Me.cbo_UserName.Value WHERE TeamListID = Me.cbo_UserName.Value"
DoCmd.RunSQL "UPDATE lut_TeamList SET UpdatedWhen = Now() WHERE TeamListID = Me.cbo_UserName.Value
DoCmd.SetWarnings True
View 5 Replies
View Related
Aug 13, 2007
Can anyone tell me what the ideal NTFS persmissions should be for users who are only inputting data to an Access database?
Would Read, Write, & Execute on the networked folder where the BE resides be enough for the users to update the database?
Thanks!
Michael
View 2 Replies
View Related
Jan 27, 2014
I have created a ribbon for the users on all forms, and named that ribbon on each form. While I can bypass the Main ribbon (hiding backstage and most other tabs) by holding the shift key on open, the minute I open a form I am stuck with the very limited form ribbon I've named. Is there a programmatic way I can ignore this call, either when holding the shift key or some other avenue?
View 14 Replies
View Related
Oct 18, 2013
I've been using Access 2007 to run queries on a database where we eventually export results as separate Excel spreadsheets for individual clients. The process is quite involved, using queries to change fields from code letters to words and splitting the database up into different client tables, saving the tables under date order and with different client codes.
I now need to pass this role on to colleagues, so need to make everything as straightforward as possible.
I had thought to use a Form as the user interface, with a minimum number of buttons, however I need either the system or the user to amend the date for the initial table, then to use this new table and run a series of standard queries on it, then produce the separate tables.
I don't think I can just use macros behind the buttons, because the database name is changing each time.
I assume some parts will be too tricky to automate - it will be necessary for colleagues to follow instructions instead.....
View 2 Replies
View Related
Jun 5, 2013
I have an Access 2003 database. I have a form with 5 tabs. I want to prevent some users from editing data on some of the tabs.
I added some logic to the OPEN property of the parent form but it does not work. "Object doesn't support this property or method." What is the correct way of controlling access of the data on the tabs?
In the logic below I first determine the user's permission for each tab. If the user has read-only access they will not be allowed to edit anything on this tab. There are 50 fields on the accounting tab and a subform. If possible, I don't want to have to specify each field individually in the code. Plus there are 5 tabs with numerous fields on each.
BTW: [add designer] is the parent form and [accounting] is the tab.
If DLookup("[permission_studentacct_ReadOnly]", "Users", "Contact_ID = " & Forms![Global]![UserID]) = True Then
Forms![Add Designer].[Accounting].AllowEdits = False
Else
End If
View 3 Replies
View Related
Feb 27, 2015
I have an access 2010 database with an initial form for user login. After selecting their login, users go to the main tabbed navigation form. On the first tab, I have form with a dashboard as a subform containing a field that says "Welcome" with the user's name (obtained from the login). My problem is, users have to click on the subform for the name field to update. How to have the name automatically populate when the login form closes.
View 2 Replies
View Related
