Results 1 to 2 of 2
  1. #1
    quahtrader is offline Novice
    Windows 7 Access 2003
    Join Date
    Feb 2010
    Posts
    5

    "Internal" timestamp on table rows?

    I have a database for my point-of-sale system, and I'm collecting some information pertaining to an embezzlement.



    Does, by chance, access store any "internal" timestamp information on table rows that can be accessed?

    For example, the application for not have a "date/time added" column - and I need to know that information. I was wondering if there was some internal, "hidden" information kept by access that would let me know the date and time that a record was added to a table.

    Thanks for any information or help!

  2. #2
    jzwp11 is offline VIP
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    Only if a field was specifically added to the table that has its default value property set by the Now() or date() functions can you have a time/date stamp for the record when it is added. If the table does not have such a field, there is no way to know when the record was added.

    Of course, if the user is given access to the field via a form or if they have access to the table directly, the value in the time/date stamp field can be altered at some point after the record is added.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. "Close form" action does not release table
    By TFisher in forum Programming
    Replies: 8
    Last Post: 10-23-2022, 11:54 AM
  2. Replies: 1
    Last Post: 05-13-2010, 10:50 AM
  3. Replies: 0
    Last Post: 03-04-2010, 06:32 PM
  4. Creating "Edit Record" link in table column
    By joshearl in forum Forms
    Replies: 1
    Last Post: 12-25-2009, 11:17 AM
  5. Replies: 21
    Last Post: 06-03-2009, 05:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums