473,378 Members | 1,321 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,378 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 2080
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: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
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$) { } ...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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...

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.