Record Creation Date

[Guest]

Is there any what I can find out when a record was created?

 

[Guest]

Only if your table includes a DateTime field with default of Now() so that it
stores the date and time when the record is created.

 

[ruralguy via AccessMonster.com]

AFAIK, not in Access unless you do your own DateTime stamp field and code.

 

[Jamie Collins]

Only if your table includes a DateTime field with default of Now() so that it
stores the date and time when the record is created.

Did you test a little? There's more to it than that:

CREATE TABLE PrivateTest
(
ID INTEGER NOT NULL UNIQUE,
date_stamp DATETIME DEFAULT NOW() NOT NULL
)
;
INSERT INTO PrivateTest (ID, date_stamp)
VALUES (1, #1990-01-01 00:00:00#)
;
SELECT ID, date_stamp
FROM PrivateTest
;

Oops! That row didn't get the correct timestamp i.e. not today's date.

The 'timestamp' column should perhaps be hidden:

CREATE VIEW PublicTest (ID) AS
SELECT ID
FROM PrivateTest
;
INSERT INTO PublicTest (ID)
VALUES (2)
;
SELECT ID, date_stamp
FROM PrivateTest
;

Now REVOKE permissions from PUBLIC on the base table and grant them
instead to the VIEW.

Jamie.

--