Solved

is there a way to get the "last updated" info on a particular table in MS Access

Posted on 2004-08-05
6
213 Views
Last Modified: 2013-12-24
Hi

I am using CF and MS Access and I was wondering is there a way to show in my .cfm page the "last updated" date of a particular table in MS Access Database

I know you can do this when you want to show the "This page was last updated on ..."  but what about a table?

Thanks




0
Comment
Question by:mdbbound
6 Comments
 
LVL 33

Assisted Solution

by:sajuks
sajuks earned 100 total points
ID: 11723937
Not possible to do that Unless you store this information in a column in your table.Or create a table log which will store the table name, date on which it was updated , the query...something like that
0
 
LVL 11

Accepted Solution

by:
hart earned 100 total points
ID: 11724312
As by updation of a table, are u talking about records or the table design was updated...
if its the records...

then keep a "lastupdated" field in each of your tables...
and when ever a record gets updated then update this field to the current date time.

And basically just query this and show it to the user...

If you want to show the table design updated date time..
Then i am not sure wether this can be done, but a work around would be to store tablenames and lastupdated in a table...
so everytime you update a table design you go and update the date time in that too...

Regards
Hart
0
 
LVL 12

Assisted Solution

by:jyokum
jyokum earned 100 total points
ID: 11725701
there are ways to do what you're asking with ADO but you'd be better off storing that information in a field in the database.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 17

Assisted Solution

by:anandkp
anandkp earned 100 total points
ID: 11726164
agree with hart ... thats how we manage it - we have every table with fields like : updatedon / updatedby ... so it becomes easy to track things l8r if required.
0
 
LVL 35

Assisted Solution

by:mrichmon
mrichmon earned 100 total points
ID: 11726990
The question you should be asking is what is the reason to even need a "last updated" field for a table.

Are you looking at the last time the DESIGN of the table was updated? (structure changed)
The last time a RECORD within the table was update? (contents changed)
The last time a RECORD was added to the table? (length and size changed)

Some combination of the above?

I really don't see a need for this from a cf application.  Which is something you may want to consider since your other post asks if you are using CF too much....
0
 

Author Comment

by:mdbbound
ID: 11730671
Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now