Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 227
  • Last Modified:

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

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
mdbbound
Asked:
mdbbound
5 Solutions
 
sajuksCommented:
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
 
hartCommented:
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
 
jyokumCommented:
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
anandkpCommented:
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
 
mrichmonCommented:
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
 
mdbboundAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now