Results 1 to 5 of 5
  1. #1
    virencm is offline Novice
    Windows 7 32bit Access 2016
    Join Date
    Jun 2019
    Posts
    5

    Get the created and modified date of a table in another database

    Hi Guys,



    Please help me with this one...

    I want to show a created and modified date of a table on a form in my current database.

    So I have a back end database that holds all my tables and its connected to the front end by links. Some of these tables get replaced / or modified overnight by macros.

    How do I show these dates on my front end forms for certain tables?

    Thanks for your help in advance.

    V

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,713
    If you open Access and look at the All Access Objects
    Click image for larger version. 

Name:	allAccessObjectsList.PNG 
Views:	11 
Size:	9.7 KB 
ID:	40886


    right click to get
    Click image for larger version. 

Name:	AllAccessObjectsRightClick.PNG 
Views:	11 
Size:	26.7 KB 
ID:	40887


    Select Details to get
    Click image for larger version. 

Name:	AllAccessObjectsDetails.PNG 
Views:	11 
Size:	23.2 KB 
ID:	40888

  3. #3
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8,020
    when you say modified - do you mean the data or the table design? A change of data will not change the table modified value

    In vba you can find the properties which are called datecreated and lastmodified with

    currentdb.tabledefs("myTable").DateCreated
    currentdb.tabledefs("myTable").LastModified

    not tested but I suspect these relate to the linked table object - if you want to check the backend table you will need to open the backend - but will depend on how your overnight macros work and indeed what the backend is, requirement will be different for an access be v a sql server be

  4. #4
    virencm is offline Novice
    Windows 7 32bit Access 2016
    Join Date
    Jun 2019
    Posts
    5
    Hi Ajax,

    Thanks for your response.

    the code below lists the date created and last modified in the current DB. I have a Backend that refresh tables daily and i want it to reflect dates from the backend. The front end has linked tables and the dates don't change on them.

    currentdb.tabledefs("myTable").DateCreated
    currentdb.tabledefs("myTable").LastModified

    Thanks

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,877
    If you can't store the date in the tables in question, can you store the table name and the current date in a table just for this purpose when your macros run?
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

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

Similar Threads

  1. Date Created and Date last modified
    By Detectiveclem in forum Access
    Replies: 6
    Last Post: 08-29-2018, 10:15 AM
  2. Do you need to have both Created and Modified timestamp?
    By JensenBreck in forum Database Design
    Replies: 2
    Last Post: 10-25-2017, 12:23 PM
  3. Replies: 15
    Last Post: 12-07-2014, 06:22 AM
  4. Replies: 4
    Last Post: 03-06-2013, 02:32 PM
  5. Replies: 5
    Last Post: 12-18-2012, 02:37 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
  •  
Tech Forums: Microsoft Office Forums