Access to Web Page time stamp

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.

Thanks!
LVL 1
NightofthecowAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

wstuphCommented:
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.  
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RCorfmanCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

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.