Add timestamp to table

[hmstoo44dd]

I need to add a timestamp to our customers table so we can update data with MS Access. Can anyone point me in the right direction? Is there a thread here that will help?

Thanks

 

[bborissov]

What you need?
One field that fill show you when that record is inserted or every time something changed in that table that field should be changed also?

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[hmstoo44dd]

In order to update tables with bit fields with MS Access you need to add a timestamp. This is a technote from microsoft.

 

[SQLSister]

Look up the alter table statement in books online.
Create a column name it what you want and use the timestamp data type.

"NOTHING is more important in a database than integrity." ESquared