How To Track User Logins
Oct 3, 2005Hi,
I thought this was posted here in the past, but I can't find it. I need a way to track when users log into an access database (username and time).
Is there an easy way to do this?
Thanks,
Keith
ADVERTISEMENT
Need User Logins To Work...
Jun 5, 2006I am messing with the user logins and groups. I got it to work on my computer but...It only works on my computer and with every database I open. No other computers get a request for a login and password and the file just opens up.
How can I get a nice login for people at our work?
Track User Changes
May 17, 2007Is it possible to identify the user and date of a change made to a record in an Access 2003 Database retroactively the built in securiy features were not turned on?
View 2 Replies View RelatedModules & VBA :: Track User Log In And Out
Mar 27, 2014I want to be able to track users log-ins on my DB, basically when a user enters their username and password I want the the time they log in and their username recorded in table. I tried doing it from the database found here: [URL] .... but I cant get it to work.
View 1 Replies View RelatedGeneral :: Keep Track Of All Permits Per Year Per User In Same Table
Dec 3, 2012We have a db to register permits that count for one calendar year. This since 2012. For next year, permits must be renewed. How can we keep track of all permits per year per user in the same table ? We would like to produce annual statistics as well ? Easy solution would have been to copy the existing table for the year 2012 and paste as a new table for year 2013 but we don't know yet who will renew his permit ...
View 3 Replies View RelatedTrack Order In Which User Selects Items From A List
May 11, 2012I am trying to find out if there is a way to track the order in which items are selected from a list. I am a dabbler and any keyword searches that I can think of don't bring up what I am looking. So, here is what I am trying to do:
I have a table of symptoms with 3 fields (ID, Category, and Symptom).I have a combo box that will allows the user to pick a category (using select Distinct on category field). I then have a list box populated with all the symptoms that have a category of whatever the user selected. The problem I am having is that I need to somehow track the order in which the user selects symptoms and then save that order for future reference and to be printed on a report. The order is important because the most severe symptom needs to be listed first.
Logins And Permissions
Oct 30, 2004Ok so my program is nearly complete...
Now I want to add permissions. So far I've gone through the very confusing security wizard and added myself and my boss to the list, but I have no idea what a workgroup is or anything. Also, how do I do permissions, like give myself full permissions, my boss almost full permissions, the secretary access to only certain forms and reports, etc.
And is there any easy way to log when someone logs in and out and what they did, etc.?
Thanks,
-Jason
Password Logins
Oct 20, 2006This attachment is an example of a loginID and Password system. Users DONT like to enter a loginID and a password. This example will get the user's loginID from windows and all you need to do is add their loginID to the admin table (or any other table for allowing users to have certain capabilities.) You can expand this to allow user's to certain forms or the ability to delete records, add records, etc. Just expand on the example with tables to do certain things.
It is much better to have a table which automatically determines if the user is in a Delete table or Admin table, etc...
I have a 2000 and XP version but I can't upload it due to limitations on upload size.
I use this technique quite often and find users like it very much as they don't want to re-enter their loginID or a password. I hope you also find it usefull. If so, please let me know.
MS Access Security Logins
Apr 1, 2004I would like to create user logins for my Access database that I would use not to prevent opening or modifying various objects (tables, forms, report) but to use for identifying the user so that when changes are made the username and time can be logged for an audit trail. Is this something I should be able to do it Access 2000. If so, how would I get the current user's name to use in my logging process.
Thanks ahead of time for any help provided!
Paul
Tracking Valid/Invalid Logins
Nov 17, 2007Hello,
I apologize if this is already a thread, but I tried my best to search for it and nothing helped. Alright, I set up low-level security for my database using the security wizard and I was wondering if there is a way to track information (username, date/time, etc.) from the auto-generated logon window. I started out making my own login window, but I couldn't get my permissions set up properly, so I figured the given security measures would be best. Everything works fine, I just need a way to track the logins. Any help would be appreciated, thanks!!
Track Changes
May 30, 2006Hallo Everyone,
I am working with the database that consists of more than 15 tables with more than 50000 records and the problem is that more than 10 people use the database. So in this case I am not sure whether who has the changed the data in it.
So for this reason i need to create a logfile to determine what are all the changes made in the data in the database with the user who uses that.
(I need to create a history and save it.)
is that possible in MS ACCESS? if so can anyone tell me some suggestion
aravind.s
Am I On The Right Track?
Apr 14, 2005Hi! I am new to Access and am trying to create a database for my customers that tells me what product/service they avail of and the status of their payments.
My tables are
Customer Info
CustomerID
LastName
FirstName
Address
ContactNo
Products (A,B,C) ( A customer can only purchase one product)
CustomerID
ProductID
PaymentSchedule (Annual, Quarterly, Monthly)
CustomerID
PaymentSchedule
Annual Product Fees
Product
Fee
Quarterly Product Fees
Product
TotalFee
QuarterlyFee
Monthly Product Fees
Product
TotalFee
Downpayment
MonthlyFee
Am I doing ok so far? I wasn't sure How to make my tables since the amount payable is dependent on both the product type and the payment schedule. Any suggestions?
Track Changes By Users
Mar 8, 2006What is the simplest way to track who is making a change to a record and when they made the change? I've tried searching for help but I'm not quite grasping how to do this. Any ideas?
View 13 Replies View RelatedHow To Keep Track Of Hours?
Feb 5, 2005Hi, I am trying to figure out a way to keep record of store hours, and days open for lots of different restaurants. The only thing I could up with is the following. I'm not sure how to keep track of store hours, or even the best way to make a table for hours. Any help is appreciated, thanks.
tblRestaurant
RestaurantID (pk)
tblRestaurantDays
RestaurantID(pk)
DayID(pk)
tblDays
DayID(pk)
DayName
tblHours
HourID(pk)
Time
Track Field Value Changes. Please Help
Jan 24, 2006Hi. I have a form with many fields. I want to track changes av 1 field to know the field value has been changed or not. I know about onchange event, but this only works when user inserts or changes the value. My form is being updated by macro/visual Basic. Is there any way to fin out if the value of a field has been changed automatically?
Thanks for any help!
metad
Track Users
Aug 22, 2004hello all... i tried to search an answer for my questions but i couldn't...
what is the easiest way to track users and their login time???
Track Changes Made To Database
Mar 15, 2006Hi guys,
Im fairly new to MS Access and have recently created a simple database to track the details of people in my department.
The database is on a shared drive and the idea was that when the details of the individual change, they open the database themselves and edit the appropiate field.
However, is it possible to track the changes that people make over a certain period (ie every month).
Thanking you in advance,
Jonny
How To Track Utility Bills???
Jan 24, 2007I'm interested in tracking monthly utility bills....monthly charges, units/volumes, costs per unit and so on, by monthly date. Would I be OK using a single table for my data, since it only involves gas, electric and water each month? How would I chart the data, so I could see trends (i.e., cost per volume, etc.)
Are there any sample projects out there that I might be able to adapt to what I'm interested in?
I'd be most appreciative if anyone has a comment, idea or suggestion. Thanks in advance!!
How To Keep Track Of Documentation For BE / FE Revisions
Apr 1, 2007Hello everyone,
I have been wondering about how I'm going to keep track of revisions for one of my databases.
Currently, I have the database split into a Back End (BE) and Front End (FE). In the work environment, the BE sits on the server, whilst all other 4 machines get a local copy of the FE. All table data in stored in the BE and linked to the FE.
I have recently got my act together and started documenting all the revisions I make to the BE and FE of the database. To do so, I created two tables with the following fields:
RevID (PK Auto increment),
RevDate
RevNumber
RevisionNotes
TimeDateStamp
I called them tblRevisions_FE, tblRevisions_BE. I placed both tables in the BE.
Whenever I make changes to BE / FE, I record it in the appropriate table.
However, because I often work on the FE of the database off site, I don't have access to the BE table (tblRevisions_FE) to record the new changes for the FE.
One alternative I thought of was just recording the revisions in a text document, and asking the client to manually record these in the tblRevisions_FE (via a FE form).
I did have tblRevisions_FE located in the FE, but when each db user got a copy of the FE, there would also be 4 copies of the table floating around.
Does anyone have any suggestions about how to manage documentation of FE revisions in this situation?
Track/log Changes To Live Data
Mar 11, 2008I have created a database that I am happy with, and I am about to receive information to populate it with. I know I am about to be asked to about security and logging of changes made to the data, which I know nothing about!!
As a result before I get into this part of my project I would like to know myself what is and what is not possible!!
Currently I have 2 tables and 3 forms, one of which is a sub form........ All changes will be done via the forms, adding new records, editing existing records or even deleting obsolete records.
•Is it possible to record any changes made to the live data?
oFor this to happen I presume that I need to setup users and access rights?
•What type of information can be saved if any?
oWhat form would this be saved in and where (a temp table?)?
While typing this a change of plan – if it is possible I am going to start building it regardless, as it will enhance my database.
Thanks
Track Missing Records
Sep 12, 2005Hello people. Iam having a problem and i need some help.
iam appending data in one table to data in another another.
I have two tables(table1 and table2), with the same fields but the records in one table2 are 5 more than those in table1 which are 3.
The 3 records in table1 are also in table2.
I would like a query which outputs the other 2 records that are in table2 and not in table1.
Thanks in advance.
Track Updates In A Dataset
Mar 21, 2013I have a table into which users insert records through a user form, I need to track the updates made in a record in a data set and i have a user log in function, it needs to tell me who updated last and what did they update.
View 1 Replies View RelatedKeep Track Of Stock Items By Query
Aug 14, 2006Hy, I have this db where a user can purchase and item and total stock number needs to be updated.
I can calculate how many items are left but how to update the warehause table?
I can live without table updating, but if the same item is purchased multiple times my query return incorrect values as the number from which the formula subtracts is never changed.
See attached database.
Query To Track Files Last Status
Sep 27, 2006Hi folks,
This is my first posting to this forum and I hope someone will be able to help me out with this.
I have a table called FILETRANS in a DB.Essentially this table is to track the in-flow and out-flow of files in a documentation unit.
The schema of the table is as follows
Filetrans_id Pk int Auto
Files_id int
Filetransdate date
Filestatus_id int
A filestatus can either be 1(IN) or 2 (out)
I need a query that will give me a list of all files whose last recorded status is 2(out) and vice versa.
Any help will be greatly appreciated.
Regards
Charles
Query To Track Revision History
Dec 28, 2007I would like to track the revision history of table records. To do so, I have created tables with two-key fields. A typical table is tblPO_Data. The first key field is PO_Number and the second key field is PO_Revision. Data fields follow.
A key element of this table is that each record may have any number of data fields left blank AND later revisions may only show the "changed" field values.
To Illustrate tblPO_Data:
PO_Number PO_Revision Length Width Height Weight Quant UPrice
100 _________0___________10_____15___________________2 ____20
100__________1_________________________30
100__________2_________________________35____100
200 _________0_______________________________________1 ____10
NOW I would like to create a query that lists one record for each PO number, showing the most recently revised data. The desired result would look like:
PO_Number PO_Revision Length Width Height Weight Quant UPrice
100_____________2_______10_____15_____35_____100__ ___2____20
200_____________0_________________________________ ___1____10
Please realize that this is an example. There would be numerous one to one tables for each PO number to reduce the number of blank fields (ie. only tables with changes would be get revised records).
Can someone suggest a way to create a query to accomplish the above requirements, thanks in advance, Jeff...
Track Users Computer Name & Network Name?
Nov 29, 2006I have been searching and found a few great threads about checking users but the codes there were incomplete. Is there a way to effectively log a user's name & computer name when they open your database and also log when they close/exit your database. Without them noticing but just for your own personal security incase something happens and you would like to know who all was actually working in/on the database at that specific time?
Or just something that will show me who is in the database so I dont' have to keep seeing network333 something has it open.
Thanking you all in advance, and I know I am a P.I.T.A.!