Identify Records by the User which created them.

[Randelissimo]

I want to create a report which allows me calculate the amount of records entered into the database by each User. The Users have already been setup within the Security settings of the database.

I want to know where I can relate the User to each record. If I open up the System file - this data seems to be in a hidden table called MSysAccounts.

Please Help!

Randeep

 

[Uncle Gizmo]

This subject already has quite a lot of coverage, on this site and on the internet. I suggest you do a site search and a Google search on Auditing.

 

[Randelissimo]

This subject already has quite a lot of coverage, on this site and on the internet. I suggest you do a site search and a Google search on Auditing.

My friend of wisdom (no sarc), I have tried and failed. Please, a starting point would be of great help!

 

[Randelissimo]

Auditing within Access

I have now found a way to keep a log of the Users who create / update new records in a form within my database. However, this now only provides the Users who create / ammend new records...


Is there any way I can obtain Users who created all previous records???

Somebody please help!!!

 

[KenHigg]

Not with any native Access features...

How many records?

Ken

 

[Randelissimo]

800 odd!

Any suggestions???

 

[KenHigg]

How many potential users? Perhaps slice up chunks of records by looking a the data and do smaller batch updates... Sorry still no magic 'Access' solutions come to mind...

ken

 

[Randelissimo]

Only 10 Users. What do you mean by slicing up and batching?

 

[KenHigg]

Just trying to figure out anything other than manually updating the records. Like, if you know only 1 user could have been doing records during a certain time and you had a date/time field, then you may be able to update those as a group update...

???
ken

 

[Randelissimo]

Its ok i've sorted it now - 'AUDITING' led the way...

 

[KenHigg]

What does this mean:

'AUDITING' led the way...

What did you do?

ken