User Logon Name Or ID
Feb 7, 2006How can you get the user's logon name or ID?
View RepliesHow can you get the user's logon name or ID?
View RepliesHi, 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 :)
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?
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?
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?
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
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.
: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!
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 Relatedhi 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
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.
I am building a form in access and I am trying to find a way where user input isn't possible in the associated textbox when "No" from on option box is selected.
View 3 Replies View RelatedHi guys,
I've seen different log in forms and tips on multi-user use but can't seem to find info on the following...
We have 6 people at work and I'd like to assign which user updated a form or created a new record...this would be particularly useful on the sales part of the database to track who made a call to a particular customer...
Best ideas anyone?
dazza61
I have a multi user database in Access 2000 that is on a server. The individual users have shortcuts pointing towards the server instance. One user and one user only when opening the shortcut gets the error "you do not have exclusive rights to the database" .
All other users can enter the database with no error box. I have checked the advanced setting under options and they are correct. Ironically if you go to start and open access then navigate to the database shortcut. It opens with no error.
I have two tables. The first contains details of a budget holders money allocation for a given period, and the other tracks their spend on products over that period. How can I generate a query to calculate the total running spend for each user from the "budget spend table" that will be written into the users record in the "budget allocation table".
My aim is to show details of budget allocation, total spend to date and remaining budget for each user in an Order form / report.
Can anyone please advise me on how to do this or suggest another way of doing it. Any help would be greatly appreciated.
Thanks in advance.
Regards Peter
I have a database for mutli users which is split. Front end is available separately for 3 users. These users make data entry in the same form from their front end form. This particular form has combo box that retrieves data based on selection in combo box and the use starts filling the data in the subform. Upto this, form is Ok, no problems seen.
But when the second user opens the same form from the split database front end stored in his computer, and once the second user selects another record from the combo box, first user's record also changes immediately to the record of Second user. Both users now have the same record even though the form is separately accessed from front end.
Will like to check, i have a access database which can be open up by a few users.
How can i only allow the first user who open up the database to read and write the database and the follow users who open up the access have only read access?
I need some help building what I believe is called a user end. I'm done building the tables and forms and all that jazz, now I need an interface that my boss, who knows nothing about access, can easly access and manipulate data. Of course it would be nice if I'd look nice. Is there anybody who can help or can give me link to a decent tutorial.
I already searched these forums and googled for help.
i plan to use the Group security feature for my DB.... using the user ID and password... i also want to make use of the user ID in the autopopulating of some of the field in my forms.... if for an instance the person logged in is akshal... then the a particular field named "filled in by" is to be autopopulated by the user ID (i.e. akshal)
View 2 Replies View RelatedCan someone direct me to help with setting up User rights? I've always been the only user, but now I have multiple people working from my database and want to limit there authorizations. Also, is it possible to have someone actively using the database while I continue to make changes for forms and reports?
Thanks in advance for the help.
hi. i just wanted to know how to get a litle yellow box to appear saying enter text here when the user puts the cursor over a field where hey enter text on a form. thanks
View 2 Replies View RelatedHi I am new to Access and just need some advise.
I currently have 5 different excel spreadsheets that record sales for 4 different state's then another to hold stock items.
I want to make an access database to hold all this info.
Should I make one table to record all information from the 5 spreadsheets or have a seperate table for each.
Any advise would be most appreciated.
Tks
Hi all
Well ive been using this forum for about a month now, and as an inexperianced user of Access D/B I find this forum is a wealth of information from the cream of Access programers. I have bought DVD courses of ebay in the past but has no comparison to the knowledge on this forum.
Thank you all.
Chris
Hi guys,
im a new user of Access and don't really know what im doing.
i need to make a database that will keep track of technical drawings. I need the database to be able to search for a drawing number, we might have a few of these types of equipment, so if i am adding a drawing of a different piece of the same equipment i need it to automatically generate the next number in the sequence.
This is hard to explain...
Ok, i have a load of Drawings, say they are numbered
0010-020-A-001
0020-020-A-001
0030-020-A-001
Right the first part is the type of equipment, the second is the sub-group, the thirs is the drawing type....this will all be entered by the person whois entering it into the register, the 001 at the end means it is the 001 revision of the drawing. If i have made a new revision of the drawing, say 002, i want to be able to use a form to enter the first bit of the serial number, then it will automatically tell me the next number in the sequence, and will let me fill in the other details, then i can click a button "add" or register or something and it will automatically update all the details...
....i would be so grateful if anyone knows a solution to this, or if this is even possible
thanks in advance
Cokes
I would like to welcome the users at login on my db,
I have a table that list user details which has the following fields
tblUserDetails
UserID
UserName
Password (encrypted)
UserLevelID
FirstName
LastName
EmailAddress
What I am trying to achieve is after logging in, I would have a welcome $User$ on the splash form/switchboard
So to re-cap, I would like some kinda vba coded example that will ref [FirstName]
Thanks in advance
Hi,
I want to write the code to detect that whether or not the administrator assign current user to access the database in SQL Server.
How can i detect it?
Suppose I have a database db1 in SQL Server, we assign the username to specific database. And then I linked tables from SQL Server to MS Access
When the user open the MS Access, I want the program to detect whether or not the current user has his/her name in the database from SQL Server.
How can i do that?
I just know to use is_member function, but this one is detecting user role, I want to detect whether or not administrator assign the username to the specific database from SQL Server.
Please let me know about it.
Thanks.