RE: Who deleted my records?

From: Alex (Alex_at_discussions.microsoft.com)
Date: 01/27/05 

Date: Wed, 26 Jan 2005 15:07:03 -0800

Enable C2 audit, you will be able to tell who did what when and etc....from
now on...

What happend in the past, you might not be able to find out who did it.
Maybe you can send an email to every one and ask...

Related links:
msdn.microsoft.com/library/ en-us/adminsql/ad_config_09yd.asp
http://www.databasejournal.com/features/mssql/article.php/3399241

Good luck
"Jordan" wrote:

> I have a sql server db linked (via dsn-less ODBC) via Microsoft Access. We
> use one NT authentication, and a single active directory group for the
> access to this database for reading/writing.
>
> In the past week, I have had two tables entirely cleared of data. I was
> wondering how I could find out which user deleted my records?
>
> Thanks, j
>
>
>

Relevant Pages

  • Re: Concatenate and Null Values -- Features
    ... I hate to be a pest but I have been reading ACC: Database Normalization ... Data Table and linked to this one using the Audit Number. ... I wonder if storing 07-01 (probably without the dash, ... I think I know what you're saying about learning by teaching. ...
    (microsoft.public.access.reports)
  • Re: Concatenate and Null Values -- Features
    ... tstTstID autonumber primary key ... I hate to be a pest but I have been reading ACC: Database Normalization ... Data Table and linked to this one using the Audit Number. ...
    (microsoft.public.access.reports)
  • Re: Concatenate and Null Values -- Features
    ... tstTstID autonumber primary key ... I hate to be a pest but I have been reading ACC: Database Normalization ... Data Table and linked to this one using the Audit Number. ... I think I know what you're saying about learning by teaching. ...
    (microsoft.public.access.reports)
  • Re: Basic question | run multiple queries without reconnecting
    ... How can you run multiple queries w/o reconnecting to the database? ... audit alter sequence by <indiv acct> by access; ... We do have a centralised app written in Java which connects ...
    (comp.databases.oracle.server)
  • Re: save action failed on form with multi users
    ... you make a design change. ... already the database in a different instance. ... > I have stripped away the audit log code. ... > sub Onokclick() ...
    (microsoft.public.access.formscoding)