MS Access 2007

[1Noob]

Hi Folks,

Need a little help... I am stuck... I am trying to make a Login entry screen and also an automatic log system. example: Each time someone logs in it records into the Log table that I have created

Also

is there away to record all the forms that way if anyone changes anything you can go back and see what was changed?




ill try to attached the database nvm it cant be zipped... its too large 570kb and the max i can upload is 100kb

let me kno and i will email it to you....

[HiTechCoach]

You will find examples for both here:

UtterAngel

Check out:
Audit Trail
This db demonstrates how to set up an audit trail of changes to the data including ID, Field Name, the field value before it was changed, the field valueafter it was changed, the user who did the change, and the date/time the change was made.

Boiler Plate Database
This is a moderately advance database that encorporates a number of functions such as 1) user logon 2) table reattachment 3) user tracking 4) how to control access via the use of modal switchboards and more. FYI: Username = admin; Password = admin.