Hello

Does anyone know if it is possible to have a "Last Updated" feature displayed on a web page which is only updated by an Access Database.

(I have a webpage which display products and it is only updated by the Access Database)

Is there a extension for this? Or something I can do in the Database itself?

Thanks

David

In the table(s) you update you can include a field which has its default value set to Now()

This will put a time stamp on any added records.

Then just include a recordset on your page that shows the latest timestamp. or query all updated tables to find the most recent update out of many updates and show that one.

Cheers
Leed

Thanks Leed,

Thats sort of what I want to be able to do.

But can you display the Now() Field with the records information like other fields, e.g. the product description.

What I want to do, which I dont think I explained very well before, is display when the individual record was updated or display the date of the last update to the database a the top of the webpage.

Sorry to be a pain but any ideas??

David

Yup, once you have set up your Recordset you can dispaly any field from your database as dynamic text, regardless of Data Type.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo