?
Solved

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

Posted on 2004-08-05
6
Medium Priority
?
220 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 33

Assisted Solution

by:sajuks
sajuks earned 400 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 400 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 400 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
Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

 
LVL 17

Assisted Solution

by:anandkp
anandkp earned 400 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 400 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

Create the perfect environment for any meeting

You might have a modern environment with all sorts of high-tech equipment, but what makes it worthwhile is how you seamlessly bring together the presentation with audio, video and lighting. The ATEN Control System provides integrated control and system automation.

Question has a verified solution.

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

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

764 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