Access to Web Page time stamp

Posted on 2006-04-18
Last Modified: 2008-01-09
Here at work, we have an access database that updates to a web page when we add information to it. I was wondering how it would be possible to make it so that when the database gets updated, the web page would display a time stamp of the last update. It's one of those nicety things we're looking at doing, but I know very VERY little about access. Any info you can provide I'll pass on and hand out points accordingly : )

It isn't urgent, but personally I think this is a difficult one.

Question by:Nightofthecow
    LVL 12

    Accepted Solution

    Short answer: yes

    Long answer: Yes, but the specifics depend on how you're passing data to the webpage, how the webpage is passing data to the access database, if the DB is getting information elsewhere, what the table structures look like, etc.

    You need to add a "LastUpdated" field somewhere in your database, then have the webpage query that data and display it.  Without knowing how your webpage works it's nearly impossible to give you more information about how to go about it.  
    LVL 16

    Assisted Solution

    If you are looking at just a last-updated information for any rows in the database (say on a given table), then it really isn't even dependent on the database... it would more be business rules you would build into your applications.

    It is uncleare if you are talking about a last update for a given record, or a last update of any records. If it is of a given record, then I agree completely with wstuph, you need that data to be stored with each row in the database. How you go about doing that depends on which database you are using... if it is one of the more sophisticated databases, you would capture the last udate date with a trigger on the data table so that when a record is updated, it stores the last update date of that record, then you would just display that column on the page when the record was displayed.  In the case of MS access (the only databaes I know that doesn't support triggers), you would have to build the logic into the application to update the last update date.

    If it is really just capturing the last update date of any record in a table, then there are more ways to implement it, depending on the requirements. You could still use a trigger approach, and just store a last update date into another table, designed to hold this data. Keep in mind that it will force all updates to any row in the database table to always funnel down to that one row and that will limit the concurrancy of an extremely busy application.  You could also store this on the web-server side to, and have a file that you update, then take the last modified date of the file.... this wouldn't capture direct database updates though.

    No matter what though, if you are going to display this data, the display is depended on the web-application to pick up the data from whereever it is being stored, and to display it.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Introduction After workin in a plethora of programming languages like C, Pro*C, ESQL/C, C++, VC++, VB, Java, HTML,JavaScipt etc, technologies and frameworks like JSP, Servlets, Struts, Spring, IBatis etc and databases like MS Access, SQLServer, Inf…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    779 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

    16 Experts available now in Live!

    Get 1:1 Help Now