I am hoping that someone out there will be able to help me, I am about to start developing a number of databases which will require the tracking of who has entered either a record or added notes to a record. Is there an easy way to do this automatically along with the date?
Any help would be appreciated.
6 1847 Denburt 1,356
Recognized Expert Top Contributor
What sort of environment are they in network wise? Do you know if they have a main server, are they using Active Directory?
What sort of environment are they in network wise? Do you know if they have a main server, are they using Active Directory?
So far as i know its Windows with main server other than that I dont know, does that make a difference?
Denburt 1,356
Recognized Expert Top Contributor
Well it could, does your databases currently have security setup (logon screen) when they open? One more thing how are they currently logging into their PC or do they?
ADezii 8,834
Recognized Expert Expert
I am hoping that someone out there will be able to help me, I am about to start developing a number of databases which will require the tracking of who has entered either a record or added notes to a record. Is there an easy way to do this automatically along with the date?
Any help would be appreciated.
One of my favorite methods is to create a Log File to monitor changes/edits/deletions, etc. Its simplist Format would be as follows: - Open "C:\<some directory>\LogFile.txt" For Append As #1
-
'[MyKey] is a Primary Key that uniquely identifies the Record
-
Print #1, CurrentUser & " modified Record ID# " & Me![MyKey] & " on " & Format(Now(), "ddd, mm/dd/yyyy @ hh:mm AM/PM")
-
Close #1
Output: - Admin modified Record ID# 1 on Fri, 03/23/2007 @ 11:57 AM
NOTE: All this, of course, assumes you have a Log On Procedure in place.
Thanks for the help so far, I have not started to develope the database yet, so I have not added any security as yet, idealy I would like to be able to use the windows log on if that is possible.
Denburt 1,356
Recognized Expert Top Contributor
When Active Directory is in place I like using it to keep track of who's who and who is changing what. If AD is in place then you can add a reference in VBA to "Active DS Type Library"
Then you can use something like the following: -
-
Set sysInfo = CreateObject("ADSystemInfo")
-
Set oUser = GetObject("LDAP://" & sysInfo.UserName & "")
-
intUsr = InStr(sysInfo.UserName, ",")
-
LName = Mid(sysInfo.UserName, 4, (intUsr - 5))
-
FName = Right(sysInfo.UserName, ((Len(sysInfo.UserName) - intUsr) - 1))
-
intUsr = InStr(FName, ",")
-
-
FName = Left(FName, intUsr - 1)
-
UsrNme = LName & ", " & FName
-
UsrNme = UsrNme & " " & oUser.TelephoneNumber
-
-
Me!Login = "Logged in as user name: " & Mid(Environ(29), InStr(1, Environ(29), "=") + 1)
-
Me!UName = "Welcome: " & UsrNme
-
Set sysInfo = Nothing
-
Set oUser = Nothing
-
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Tony Stoker |
last post by:
I have a .Net web app that adds a record to a SQL
database. After the user adds their record I want to
have a link that will link them to their new record! The
recordID is a AutoNumber in the SQL server...
How do I return the recordID after I have added the
record?
|
by: baskar |
last post by:
Hi,
I have a table with 90 fields. When I try to use the recordset with
addnew and set all the 90 fields and then update the record set it
fails the following error seen in the log,
SQL0117N The number of values assigned is not
the same as the number of specified or implied columns.
SQLSTATE=42802
|
by: Randy |
last post by:
Hello,
Can someone tell me what is the best way of implementing the detection of
adding a row to a datagrid. I looked at using a DataView as the datasource
and the ListChanged event, but that didn't seem to work like I expected. It
seemed to fire only when I changed to another row in the grid, not when I
clicked on the little pencil icon on...
|
by: Richard |
last post by:
In normal asp i used
---------
objRS.Open "tbl_Nieuws", objConn, 1, 3
objRS.AddNew
objRS.Fields("N_Datum") = FormatDateTime(Now(),2)
objRS.Fields("N_Title") = ReplaceHTML(Upload.Form("title"))
objRS.Fields("N_Intro") = ReplaceHTML(Upload.Form("intro"))
objRS.Fields("N_Body") = ReplaceHTML(Upload.Form("body"))
|
by: tlyczko |
last post by:
I am working on an audits database.
The main table, Audits, has an AuditID primary key.
Another table, 1:1 relationship, ProgramAudits, has AuditID as a
foreign key.
I have a master/main form for Audits data, and a child/sub form for
ProgramAudits data.
I put a subform for ProgramAudits onto the Audits table form, and the
following code...
| |
by: Kaur |
last post by:
Hi,
I am working in MS Access 2000 and have created two forms. Form 1 is
called frmParent (which has a subform called SfrmChild). FrmParent has
a list box that lists all the Last Names of parents in the db. Clicking
on one of the lastname of parent in the list box shows children of
selected parent in the SfrmChild. I have a button on...
|
by: gerbski |
last post by:
Hi all,
I am relatively new to ADO, but up to now I got things working the way
I wanted. But now I've run into somethng really annoying.
I am working in MS Access. I am using an Access frontend separately
from a backend. The tables from the backend database are linked in the
frontend database.
In the frontend there is a Form with a...
|
by: =?Utf-8?B?UHJhdmlu?= |
last post by:
We are using .net Framework 1.1
We are having one page on which we are using this Grid component.
From this page we open a popup for adding new record as well as for editing
an existing record (For Edit we want to pass the ID of that particular row)
And when user clicks on 'SAVE' button in popup window, those changes need to
be...
|
by: banderson |
last post by:
Hello,
I am having a problem getting a new record in a subform to append to the underlying table. When I add a new record to the main form, the subform is blank, except for the ID field, which is populated because of its link to the main form. I would like this new record, populated at this point only with the ID from the main form, to then be...
|
by: MerlinS |
last post by:
Using Access 2003.
I have a form and a subform.
On the main form, one of the fields is a lost box, which lists line numbers ie 1, 2, 3 etc.
Then the list box is clicked, the subform corresponding to the line number info is shown.
When a new record is added to the subform the new line number is added and is shown in the main form list box.
The...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |