Hello,

Is it possible to retrieve the date when a record is created in an Access
database table?
And if so, how can I do that?

Thanks in advance,
Jeroen Elias

On Wed, 22 Feb 2006 10:39:25 +0100, "Jeroen Elias" <j.elias (AT) bluedesk (DOT) nl> wrote:

Access doesn't store this information; you would have to add a column to every table and query the table for that info.
For example, you could add a dteTimeStamp to each table and set the DefaultValue to Now() ... this would insert the
machine date/time each time a record is added to the table.

You could then determine the creation date by this:

SELECT dteTimeStamp FROM SomeTable WHERE YourIDField=xxx

Scott McDaniel
scott (AT) takemeout_infotrakker (DOT) com
www.infotrakker.com