query to get everything done in the day?

[aceavl via AccessMonster.com]

Hi
i'm almost finished writing a DB for a company and today comes the owner and
tells me that he wants the DB to make a report of everything the users did in
the day!

i don't know if i'm too tired or what but i can't think how to go about doing
this!

any help would be greatly apreciated!

and i mean EVERY change, EVERY Update and EVERY new record made, it's a small
company and there won't be to many entries in the DB but still how to do it?

what kind of query can do all that?

 

[Guest]

Give the owner a printout of every table every day and have him/her find the
differences. If that doesn't work, consider reviewing some audit trail
samples at http://www.rogersaccesslibrary.com/TableOfContents3.asp#A.

 

[aceavl via AccessMonster.com]

Thanks Duane, i think audit trail is the way to go!

Give the owner a printout of every table every day and have him/her find the
differences. If that doesn't work, consider reviewing some audit trail
samples at http://www.rogersaccesslibrary.com/TableOfContents3.asp#A.

Hi
i'm almost finished writing a DB for a company and today comes the owner and

[quoted text clipped - 10 lines]

what kind of query can do all that?