Find Out If The User Is Admin
Aug 3, 2005Hey
On my database I did it so it checks who logs in to the machine (through API), but now I'd like to see if someone logs in to database as Admin or regular user. How is it possible ?
ADVERTISEMENT
Is The Current User A Member Of The Admin Group?
Aug 10, 2007I am setting up a call log for an application. Once a message has been entered, I need to restrict access to the person who created it AND to managers (who have admin privelages to the database). Since the user who created a message needs to be able to go back in and edit it if necessary, I can NOT simply restrict access to the edit form to admins.
The command that opens this form looks like this so far:Code:If ((Me.[Transaction] = "Status Call") And _ (Me.[TransactionBy] = CurrentUser())) THEN DoCmd.OpenForm "frmEditMessage" ...Else MsgBox("Blah blah blah, etc etc.")End IfI need to add something to the initial If statement like this:Code:Or (CurrentUser.isMemberOfGroup("Admins"))but I don't know the correct Access syntax for it.
Any help anyone can give me would be appreciated!
General :: Lock File Shows Admin User Active For All Clients
Jul 2, 2013We have a split ACC2010 database, with the back end on our server and 5 front ends on 5 client PCs. I hadn't run a compact/repair on the back end for months. When today I tried, I got the 'database is locked' error. The lock file showed 'Admin' logged on at all 5 clients. The front-ends had been closed on all 5 clients. We do not have a user called 'Admin'. Because my issue occurs for all clients, it might be caused by some sort of programming error in the front end.A VBA bug (implicit comparison to a control in an If .. Then construct) caused this type of behaviour but was resolved in Access 2007.
View 12 Replies View RelatedThe Database Has Been Placed In State By User "Admin"
Mar 13, 2007hi,
Everyone know this error? the database has been placed in state by user "Admin"!
We are using a shared database in Access 2003 that is still in Access 2000
format. When more than one user has the database open (by using the vb.net), the following error
message appears "The
database has been placed in a state by user 'Admin' on machine XXXXX that
prevents it from being opened or locked."
How to slove this error? please help! Urgent!:confused:
General :: Find User Who Has Record Open
Jun 22, 2015is there a way to find out who has a record open and send him message or someting similar?It happens from time to time that some one has a record open (selected in a form) and then is doing other things while the record is locked and a second person can't do nothing to the record.
View 14 Replies View RelatedModules & VBA :: Multi User Environment / Find First Method And Update
Aug 21, 2014I have a problem in multi user enviroment, with finding and locking a record in database.When one user finds, blocks and edit record ... another user in the same time can find the same record and overwrite it (User and Status values). It is just like he didn't see the changes making by another user.Each user have a copy of the front-end, back-end is on the shared disk.Here is the code to find new record:
Code:
...
Set rs = db.OpenRecordset("tblTable1", dbOpenDynaset)
rs.FindFirst "[Status]='New' And [User] Is Null"
ws.BeginTrans
rs.LockEdits = True
rs.Edit
rs![User] = username
rs![Status] = "Assigned"
rs.Update
ws.CommitTrans
rs.Close
Could Not Use 'Admin'; File Already In Use.
May 18, 2005I'm working on an MSAcess 2003 database and I have saved the System.mdw file to a folder on the Server and linked all users to it. When multiple users attempt to log in, they get the message
Could not use 'Admin'; filer already in use.
I have used shared system.mdw files for years with no problems. But obviously the force is not with me today.
Any help with this issue would be appreciated.
Admin Passwords
Nov 1, 2005Within our client estate, there are a number of types of machines and a number of admin passwords that go with them
I need to put an agent on each of these machines but first i need to make all the admin passwords the same or add our domain group to the local administrators on that machine.
In order to do that I need to know what the admin password is for that specific machine
So a series of attempts with various different passwords and users names are required.
so something like this maybe
dim admin1 as string
dim pass1 as string
dim admin2 as string
dim pass2 as string
dim admin3 as string
dim pass3 as string
dim admin4 as string
dim pass4 as string
call Shell("psexec \192.168.0.1 -u + admin1 + -p + pass1")
if error = 1 then
call Shell("psexec \192.168.0.1 -u + admin2 + -p + pass2")
else
end if
end
Is this the best way to approach this? - Am confused? - Thank you
Could Not Use Admin. File Already In Use
Feb 21, 2006Hi,
One of my user is getting this error when trying to launch the DB - "Could not use 'admin'. File already in use. The DB is in shared mode and other users are using it without problem. What could be the issue?
Thanks,
Not Being Recognized As Admin
Jan 5, 2007About three weeks ago, my work computer crash hardcore. Windows (2000 ver) had many corrupt files in the Windows Directory and in the Registry. Because of that, IT gave me an up to date computer running Widows XP. I am still running the same version of Office (2003 Pro).
I think because I have a new machine and a different platform, I am now have issues with trying to administer the permission rights. MS Access is not recognizing me as Admin and/or Creator of the db, therefore I am not able to modify permission rights....... :eek:
Does anyone know how make this db recognize that I am the Creator of it?
Thank you in advance for your help.:cool:
Kilch
Just An Email Admin
Apr 12, 2005I do Exchange administration, but I use Access Databases all the time to manipulate data. That is the only way I can take care of over 25,000 mailboxes with just two people.
Here is my scenario. I have two spreadsheets. First spreadsheet has UserIDs and Names. Second spreadsheet has group mailboxes and UserIDs associated with those mailboxes. I need to send an email out using Access to each of these 500 mailbox owners. In that email it must contain the name of the group mailbox and each user's name (not ID).
Examples:
Spreadsheet 1:
User01 Name1
User02 Name2
User03 Name3
User04 Name4
Spreadsheet 2:
Mailbox1 User01, User03, User04
Mailbox2 User02, User03
Mailbox3 User01, User02, User03, User04
Outgoing emails:
Mailbox1 Name1, Name3, Name4
Mailbox2 Name2, Name3
Mailbox3 Name1, Name2, Name3, Name4
I am pretty good at Excel and Access when it comes to basic data manipulation. I know how to make Access send an email out to hundreds of customers at once. Now I just need to be able to create that form letter and plug in the names where there are UserIDs.
Anyone have a suggestion (of course you do, so just put it down!).
Thanks a whole lot in advance for your assistance in this matter. And, if you have an email problem, let me know! I can prolly fix that for ya!
Don
Contract Admin For Architects
May 29, 2006I don't know who to write and thought that I would try this list. Has anyone written, or do they know of, a Contract Administration package for Architects, written in Access 2000 or later? I am an Aus architect who dabbles in Access and doesn't want to re-invent the wheel.
Any help would be appreciated.
Cornelis (Kees) Wegman
Delete Admin Account
Dec 4, 2006Hi,
After I setup user-level security, and add the new users with Admins permission.
Why I cannot delete the Admin account?
Can we delete the Admin account forever after setup user-level security?
Please let me know about it.
Thanks.
Admin Password Lost
Aug 1, 2005Hi All,
I forgot the access database admin password. Please provide me the remedy to my problem. Your response is appreciated.
Best Regards,
Saied Aliuzzama
General :: Admin Has No Permissions At All
Jul 16, 2013Now there is only one set of permissions Admin, and Admin has no permissions at all. When I try to check admin rights or even read rights back to the Admin it says I need to be logged in as admin, which I am.
Is there anyway at all I can either copy some information from 2 tables and put it in my back up?? I'm really stuck here and need to fix this or I'll have lost considerable amounts of work.
Securing The Database So Only Admin Can Make Changes.
Feb 7, 2006I've been fiddling around with the Tools>>Security settings but I can't seem to find a way where only I can make changes to the database and the users can't just use the switchboard. If you are regular user you don't need password but if you are admin you do.
How do I do that?
Any Good Links For An Auto DB Admin Prog
Jun 9, 2006Does anyone have an updated link to a free utility download that will auto create a backup of my database as well as do a compact and repair at a scheduled time each week. Maybe twice a week if possible! :p
View 5 Replies View RelatedAdmin Issues When Copying Database To New Network
May 24, 2007When attempting to open an Access DB that has been transferred from one network to another (via CD and aeroplane!) we are finding that the copy cannot be edited - the access is effectively read only... I believe this has something to do with Workgroup admin rights but this area is all a bit confusing for me. What do I need to do to open the copy up for editing - allowing the recipients to administrate their copy of the DB?
We're using Access 2002.
! How Do U Create Admin Account In Command Prompt?
Mar 22, 2006does anyone know the code for command prompt to create an administrator account over a network???
View 2 Replies View RelatedModules & VBA :: Separate Users And Admin On Login
Jul 8, 2014I 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] .....
Access Admin/Contractor Needed, Easy Project.
Jun 27, 2005Hey i need some one that knows Access to help with a work Database, and just make sure everything is working and set properly.
This is for a Construction Managment Company.
Email me at *email removed* for more info, and i can send out the DB to be looked at.
Thanks
Kevin Maguire
President
GOT LOCAL MUSIC
Creating Admin Function To Validate Time And Task
Feb 19, 2007Hi all,
was wondering if there was a simple way out there, or if someone could give me some ideas on how to use an admin function to either approve or deny a users time and tasks... this wouldnt neccesarily have to a be a daily function... but i would like to have this done before the end of a pay period(2 weeks).
i feel like this could be as simple as using a check box to show approval, but i wouldnt know how to have the users submission go into a place where the admin could view to approve or deny.. has anyone seen something like this done before?
thanks in advance
Reversing Startup Settings With Passworded Admin Access If Possible?
Mar 19, 2007Thought I best ask this question BEFORE I run into trouble.
If I were to set my database to hide the database window and all menus on startup so that users can only do what I want them to do and not edit anything. How do I go about reversing this if I needed to edit something as I would not be able to see any of the regular menus?
It would be good if the solution involved some sort of admin password rather than a sneaky short cut that a user may accidently stumble across.
General :: Set Password For Tables And Forms - Allow Admin View Only
Apr 21, 2013I have a receptionist which uses a database that contains everything in the company ..there is an employee table that contains their salaries and I want to set password for this table so that the admin is the only person who can view this table .......... is that possible?? And the same thing for a form that controls this table!
View 4 Replies View RelatedModules & VBA :: Change System Date / Time Without Admin Privileges
Mar 31, 2014I have an Access 2010 application running on Win 7 Pro which connects to a Back End SQL Server database. I am trying to get Access to synchronise the client pc system date & time with the Sql server date and time. Please note, the date/time does not necessarily have to be correct, it just has to be consistent between the server and all the pcs running the Access application.
I have tried two methods as follows. But both only work if Access with Administrator privileges, which isn't really practical.
Method 1:
Code:
Dim MyDateTime As Date
'Some Code here to get MyDateTime
If MsgBox("Change date & time to:" & vbCrLf & vbCrLf & MyDateTime & "?", vbYesNo, "Change") = vbYes Then
Date = DateValue(MyDateTime)
Time = TimeValue(MyDateTime)
End If
Method 2:
Code:
Private Type SYSTEMTIME
wYear As Integer
wMonth As Integer
wDayOfWeek As Integer
wDay As Integer
[Code] .....
General :: Login To See Own Records But Admin To See All Records
Dec 16, 2013I have a user login code am using for users to login and only access their records in a subform according to their user ID and access level (user or admin). On the main form I have a user name field, the password field and two other fields: one to hold userID and the other to hold access level.
I also want if the person logged in has "Admin" access level the subform should return records from all users. For now what is happening is that even when I assign myself with "Admin" access level, the subform is not returning all records from other users, but my own records only. The original demo where I found the code worked well but I cannot find it and I am totally lost on this.
Here is the code I have so far:
Code:
Private Sub cmdLogin_Click()
Me.Hold_User_ID = Nz(DLookup("User_ID", "T_Users", "Username='" & Me.UserName & "' and pword='" & Me.PWD & "'"), -1)
' check to see if we have a good login
If Me.Hold_User_ID = -1 Then
MsgBox "Invalid username or password."
[code]...