473,387 Members | 1,664 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

User activity report - Access 2003 (Newbie)

Hello Everyone,
I have been researching and researching for a method to generate a report for security/auditing purposes to track any changes (i.e. creations, deletions or modifications) to the database on a user level. I have setup the database security by using the user-level wizard. If anyone could point me in the right direction on how to accomplish this task, I would appreciate it greatly. Please let me know if I need to provide additional information on what I'm trying to accomplish. Thanks in advance.

Regards,
Greg
Apr 5 '07 #1
3 2081
MMcCarthy
14,534 Expert Mod 8TB
Hello Everyone,
I have been researching and researching for a method to generate a report for security/auditing purposes to track any changes (i.e. creations, deletions or modifications) to the database on a user level. I have setup the database security by using the user-level wizard. If anyone could point me in the right direction on how to accomplish this task, I would appreciate it greatly. Please let me know if I need to provide additional information on what I'm trying to accomplish. Thanks in advance.

Regards,
Greg
You will need to create a log and add a record to that log whenever a record is added, edited or deleted with the username and timestamp also being recorded.

Mary
Apr 6 '07 #2
You will need to create a log and add a record to that log whenever a record is added, edited or deleted with the username and timestamp also being recorded.
Mary,
Thanks, I appreciate the info.

Greg
Apr 6 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
Mary,
Thanks, I appreciate the info.

Greg
You're welcome.
Apr 6 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Kenneth Courville | last post by:
Hello, I have an application that will be logging to a SQL Server 2000 database user user activity from several Windows 2003 terminal servers. This information will be retrieved by monitoring...
1
by: Jean-Paul | last post by:
caveat: I am learning access and this is my first usenet post ever. if there is a more appropriate place for my questions, please let me know. I have created a grants management database and am...
3
by: RC | last post by:
I can't quite grasp the concept of creating custom reports depending upon what options a user picks on a Form. For example, the user clicks on a "Print Reports" button and a Form pops up. On the...
2
by: Del | last post by:
Thanks in advance for any help. I have a database that was created in Access 2000. Several users have been upgraded to Access 2003. Since upgrading to 2003 we have noticed that some of the...
5
by: bcanavan | last post by:
When I export xml(and xls) from Access 2003 the result is a complete report in a single page. I would like to get the entire report in a single page (one trip to the server) for printing and...
13
by: i. Wiin | last post by:
I've got a daily based crystal report that doesn't show 0's for days where no activity occurred. How do I get 0 values to show up in the report?
0
by: Rahul Chatterjee | last post by:
Hello All I have designed a dotnet application using VB which basically takes a selection and passes value to a crystal report which in turn passes the value to a Stored procedure. After the...
5
by: Linds | last post by:
I have a report within my access database that I would like to have a shortcut on my desktop that could bring up that report. In other words, now I have to double click on the database, then go...
32
by: wexx | last post by:
I have been looking for some time now (reading books off Safari, searching through forums,etc) I have found no solution to this problem. I turn to anyone of you that may be able to help me. I'm...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.