I want fields audited as well as the entire table. for example if someone enters data into a field, closes out of the database then goes back in and edits that field they want an indicator to tell them when and what time did they do that. Does that make sense??? I was trying to find a date function I could use to do that

The database I am using is SQL Server 2005 with an Access 2003 front end

You could use table triggers to check for updated values and write a record to an audit table. The trigger could test for change to each individual column so you could get very specific.

-Peter