Timestamp 2

[yorrick]

Hi all,

Access FrontEnd, SQL Server 2000 backend.

I need to add a Timestamp field to a table what do I do?
In baby steps?!

Is it a case of going to SQL SERVER and adding the Field in there, because I can't see a way of doing it directly from Access?

Is this correct?

regards

Yorrick

 

[PHV]

Yes, do it in SQL Server and then in access refresh the link.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jsteph]

yorrick,
Be careful, the SQL-Server 'Timestamp' field is not a date/time. If a true date/time is what you want, then use the datetime data type and use getdate() as Default and use a trigger to change it on updates--avoid using Access to insert the datetime and update it--each client may have vastly different system times.

The Timestamp datatype is a value which you can use to tell the relative 'age' of a record, it but has nothing to do with clock time.
--Jim