Solved

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

Posted on 2004-08-05
6
217 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 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
Save the day with this special offer from ATEN!

Save 30% on the CV211 using promo code EXPERTS30 now through April 30th. The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

 
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

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

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

Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

730 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