Previously posted in General but got no response so decided to move to forms area.
I want to hide as many toolbar options/menus as I can on startup, so the user is very limited as to what they can do with the database.
I am using the multiuser logon option so each user has their own user name and password.
By hiding the menu, it also locks out the option to change their password.
I want to give users the ability to load the User and Group accounts/change logon screen only.
What I was thinking was calling this option from a command button on a form.
ie, Once clicked, it takes you to the generic Change Logon screen with the need for the menus to be enabled.
Can this be done?
If not, is there an alternative.
Every time I open up access I get a logon box which asks for the admin password. This applies to any database project I open. I for the life of me can't figure out how it was turned on, but it still has the generic password associated with it(thank god).
I am trying to rid myself of having to type it in every single time I open up a database project. I have tried to delete it in the security section of tools and it won't allow me to delete the admin.
This is incredibly annoying because neither of the database projects requires a password, and I am not even the one that created the projects. I am merely a user.
Any suggestions on how to rid myself of this annoying problem?
hi there, I'd like to ask the solution for my problem. I made a new project using ms access 2003,crystal report 9, and visual studio 2005.
I just made a simple access dbase with 1 table(Table 1) and protected with password, o I forgot this table has 2 field(id and desc). After that I made simple report that using DAO connectivity(save data with report option is disabled).
At last I made simple program(windows app) using visual studio 2005. I put the CrystalReportViewer component, and these is the code :
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms;
namespace prj { public partial class Form1 : Form { public Form1() { InitializeComponent(); }
and the problem is when I move the access database file to other location, the viewer shows a box to be confirmed by my UserID and password, my question is how must I write in the program so that the box doesnt come out.
I am using the sample security db that has been posted on previous threads does anyone know how to add a change password button to it, any help would be appreciated.
Hi i followed the link below http://support.microsoft.com/kb/179371 and was successful to put the password on my form. my question is how do i change the default password to my own. i have tried but failed. Any help will highly aprreciated
I want my text box to display a social security number like this: "*****6789". 5 asterisks and last four numerals displayed. I am familiar with the "Password" Input mask but I think it only allows the entire field to be masked. Can I make a custom mask like this?
So I have a login system established with loginID, passwords, and different user types. I also have a User Change Password form. However, this form only allows the user to change their password to something new. Also, for some reason the form only allows the first user in the table (ID#1) to be changed regardless of who is logged in. I was using an embedded Macro. I need to be able to have the old password entered and verified before the password can be changed to something new.
Private Sub Command3_Click() If IsNull(Me.cboEmployee) Or Me.cboEmployee = "" Then MsgBox "You must enter a User Name.", vbOKOnly, "Required Data" Me.cboEmployee.SetFocus Exit Sub End If
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
Hi! This is Kishore, working on VB Project which is using MS-Access95 as backend. Now, i want to change the Database login Password. Could anyone guide me in this context.
Hi, i want to add security into my database, but i dont want to use the built-in workgroup security.
Is it possible to create a login screen that will allow different access rights depending on the username? If so can sum1 please help me with the code?
I use MS Access a lot for my work but a few days ago when I opened Access it asked for a username and password. I didn't set anyway passwords so tried to log on using the username: admin and a blank password which didn't work. I have tried every username and password combination that I could have used but nothing seems to work.
Is there anyway for sorting this out so that I can use Access again?
I have a database that I have secured by using Access 2003 user security. I need for the database to allow the user to login and once they have logged, to open a form and filter out only their open "tickets" - records.
:confused: :( I think I am in the correct area of this forums, if I am not, please forgive me. Anyway, this is way over the top of my head and I need desperate help! Here goes…..I am finally finished exporting an Excel spreadsheet that contained over 6,000 entries into a continuous form in Access 2003, and before I move it to the shared drive, I have a few questions/concerns.
I work with a group of employees totaling 15. Out of the 15 of us, 4 will be issued editing rights, and the others read only rights and I will be the administrator/creator/owner of the database. Here are my concerns:
1. It is a MUST that the 4 with editing rights be able to work in the same form, (the form consists of daily updates i.e.: (purging, entering, deleting and fixing of data) in different areas of this form, and maybe at the same time?
2. In addition, will the 4 of us be able to save the updates entered separately, and have the most recent data which was entered updated for others to view? (I know in Excel we were able to do so).
3. Will the users with read only rights be able to fill out other forms in the database or should I assign some degree of editing rights?
4. Also, although rare, will there be a problem if all 15 employees are in the same database completing other forms at the same time?
5. We have a few employees who work from home and log into our system via Citrix. Will they have a problem logging into the database and completing the forms?
This is where I am TOTALLY CLUELESS and need help DESPERATELY!! Is there a step by step way of doing this? (please say yes! please say yes!) I am sure I will need to create a shortcut for all users and I will also need help on how to do that also. Currently, there is no user id or password set up for anyone of us since we have a specific shared drive designated for our group/department.
I have a logon form that always contains a value in the user name and password fields. How can I do it that these two fields are empty when the logon form is displayed? When I put this code in a program text12.value="" then it delete user name in database.
I have recently split my database and added a password to the back end. I am now trying to re-link the tables as I have seen in other threads, but when I do this I am not prompted for the password I just get the message 'Not a valid password'
I must obviously be doing something wrong, can anyone help?
Firstly thank you for your help, this should be a simple one I hope, but is cracking my head on the wall. Have searched and searched and can't find an answer.
I have an Access Db that is not password protected, but is asking for a password. It opens on any other machine fine?
I think my version of Access is playing funny buggers with me, any suggestions?
I was trying to implement some security on this Db, which is why it happened I'm sure. I ran the security wizard, set-up two users and admin with passwords, I have the output file to "recreate" something too.
Issue is, I then copied this Db to another computer for use on there, it worked without a Password, so didn't need to worry about it, now I can't open any Db on my machine??
i have found a code that brings up a box when tab or clicking in to a box for editing as below:-
Dim strPassword As String If InputBox("Please enter the password:") <> strPassword Then SomeOtherControl.SetFocus TextBox1.Locked = True End If
its just that need to add a password as well, i have tried to put this in between the <> but this does not work. i would like a message to say incorrect password as well if possable.
