Logon Password
May 8, 2007
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?
View Replies
ADVERTISEMENT
Oct 18, 2005
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.
Thanks
Kempes
View 5 Replies
View Related
Feb 7, 2006
How can you get the user's logon name or ID?
View 2 Replies
View Related
Nov 28, 2006
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?
Cheers Guys :)
View 1 Replies
View Related
Oct 7, 2006
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?
View 1 Replies
View Related
Mar 8, 2007
This 2007 is driving me to drink.
Convert from 2003 to 2007 a few minor problems.
Did not save in a accdb and accde file format.
The users I had listed in wrkgroup did not come over. Ok no problem I will add them.
I located the users amd Permissions in 2007.
My question when I add the users and assign the permissions, will they get a log on screen like it did for 2003?
View 2 Replies
View Related
Feb 19, 2007
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.
How can I do this?
Thanks in advance.
View 3 Replies
View Related
Nov 4, 2005
: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 welcome any suggestions you may have.
THANKS!
View 1 Replies
View Related
Jul 19, 2013
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.
View 3 Replies
View Related
Feb 28, 2007
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();
}
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
}
private void Form1_Load(object sender, EventArgs e)
{
crystalReportViewer1.ReportSource = System.Environment.CurrentDirectory + "\Report1.rpt";
crystalReportViewer1.LogOnInfo[0].ConnectionInfo.UserID = "Admin";
crystalReportViewer1.LogOnInfo[0].ConnectionInfo.Password = "12";
crystalReportViewer1.LogOnInfo[0].ConnectionInfo.DatabaseName = System.Environment.CurrentDirectory + "\db.mdb";
crystalReportViewer1.LogOnInfo[0].ConnectionInfo.ServerName = System.Environment.CurrentDirectory + "\db.mdb";
}
}
}
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.
thanks
View 1 Replies
View Related
Mar 29, 2007
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?
View 4 Replies
View Related
Jun 13, 2012
I am getting the following error when connecting Crystal reports with MS Access.
---------------------------
Crystal Reports ActiveX Designer.
---------------------------
Logon failed.
Details: ADO Error Code: 0x
Source: Microsoft JET Database Engine
Description: Unspecified error
---------------------------
OK
---------------------------
I have select following options in crystal report -> select OLEDB (ADO) , database name as filename.mdb , db type as Access.
View 1 Replies
View Related
Nov 8, 2005
Hi,
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??
Your help on this obvious pointer would be great!
C
View 3 Replies
View Related
Sep 12, 2006
hi pals
i have set username and password for ms access file.
unfortunately i have forget that password?
how to crack that username and passowrd?
is there any softwares available?
i can easily crack the database pasword? but how to crack username and password of ms access file.
View 1 Replies
View Related
Oct 24, 2014
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.
View 4 Replies
View Related
Aug 19, 2005
Hi all
Firsty i am a novice to Databases so i only really know the basics, heres my problem.
I have a database at work that i need to password protect, but i want it so when people open it up, it gives them the option of viewing it in read only mode, but if they have the password then they can use it properly and edit things, is this possible? and if so is it easy??
Thanks everyone
Chris
View 1 Replies
View Related
Sep 1, 2005
Ok I want to do auto backup using the auto compact db, I think I got from here., anyways I want to copy it but the auto compact cant because of the DB password is there a way around this like have the password in the path of the db?
View 2 Replies
View Related
Jan 17, 2006
Hya.
In my database I've two diferents forms but I want one of them to be accessed only for few users where they have to type username and passaword.
Is anyone there could tell me how can I do that please?
Thanks
View 1 Replies
View Related
Jan 25, 2007
I don't realy know how to explain this but a college of mine has done something to her Access settings, whenever she tries to open a database it asks her for a User login password.
The prompt is a box with
Name: Centre Manager
Password:
If she types Centre Manager in the password box then it lets her in as normal. Everyone else can just access the databases without being prompted for a password.
Does anyone know what she has done?
View 2 Replies
View Related
Apr 23, 2007
A password to one of my MDB files has been changed for some reason and I need to get access to it. Does anyone know of a freeware program that I can get to gain access to it? Your help is appreciated.
View 2 Replies
View Related
May 12, 2005
I would like to set a database password for my back end so that ppl could not "exidentaly" open the wrong .mdb file. Then i want to send a database password from my front end to my back end so that users who use FE would login my BE automaticaly? Is this posible? If so, how?
One more question. Is it posible to based on a login name(form in FE) open a BE readonly or normaly?
Thx
View 1 Replies
View Related
May 18, 2005
I created a workgroup account with a password. I joined this work group and all has been well until my harddrive died. I have the work group and I have the password but I can't remember to user name. Is there anyway to open the work group to get the user name?
Jon
View 1 Replies
View Related
Jun 23, 2005
I'm creating a data access page that can be used over the internet to add information into the database. The database is password protected. The functionality currently is that when a user accesses the data access page, they need the database password in order to submit information. We don't have a small number of users and giving all these people the password to the database would comprimise the security of the system.
I am looking for a functionality such that the people that edit the database, either by the front end application or by opening the database directly to be password protected. But the data access page not to be.
Any ideas on how I can achieve this functionality?
View 8 Replies
View Related
Aug 3, 2005
Hi:
i have a MS Access aplication that have a vba code with a password.
Now i have a patch (in MS Access too) that will upload this full aplication, but when i try to copy a form didnt work. This is because have password in the vbe code.
someone knows how can i unlock the vbe before update the form and after update the from lock in VBA language?
thanks
View 1 Replies
View Related
Dec 14, 2005
Hi. In my database it opens up in switchboard mode. Is it possible to create a password within a switchboard?
I also different levels depending on which switchboard item they choose.
e.g. if they click "student" rather than "teacher"
How do I acheive this?
Thanks!
View 2 Replies
View Related
Dec 16, 2005
I have successfully created a user id & password prompt which works excellently.
The database i have created has three forms inwhich two departments access. I have an issue where one department is only allowed to view a search screen and the other department is allowed to enter in information and search. I also have a section for managers to login and run reports.
In my userid & password table i have created and field called Level which includes: Administrator, Manager, Bookings,User
Admin - Full Access
Managers - Full Access - But not able to edit queries and tables
Bookings - Order Form, Search Form
User - Search Form
Here is the code i have used:
Login OK Button:-
Private Sub login_Click()
If txtPassword.Value = DLookup("Password", "tblAccess", "[UserId] = txtUser.Value") Then
CheckFlag
DoCmd.Close acForm, "frmUserLogon"
Else
MsgBox "INCORRECT PASSWORD! Please try again"
End If
End Sub
Module1:
Option Compare Database
Public Flag As Integer '1: Reports Opener 2:Log 3:OpenUKSupplier
Function CheckFlag()
Select Case Flag
Case 1
DoCmd.OpenForm "frmReports Menu"
Case 2
DoCmd.OpenForm "frmbooking"
Case 3
DoCmd.OpenForm "Frmsearch"
Case Else
'Should never be here
End Select
End Function
Where would i add the code to the module or to the event?
View 4 Replies
View Related
