[AccessD] New thrd: dates

Gustav Brock gustav at cactus.dk
Sat Aug 23 04:39:13 CDT 2014


Hi Bill

You can say that with an Access backend, a timestamp has to be produced by the frontend, while with a server backend like SQL Server, a timestamp is normally produced by the backend engine. However, the nature of those timestamps may be very different. For SQL Server, a timestamp is not readable as a time, it's for internal use only.

/gustav
________________________________________
Fra: accessd-bounces at databaseadvisors.com <accessd-bounces at databaseadvisors.com> på vegne af Bill Benson <bensonforums at gmail.com>
Sendt: 22. august 2014 22:29
Til: 'Access Developers discussion and problem solving'
Emne: Re: [AccessD] New thrd: dates

Thanks Gustav,

I used to work for a business who wanted me to assign a date stamp to a
variable and stamp all records with that date. That was on an Access
backend. I think in SS and Oracle, this is done (as Jim suggested) with
back-end processes ("triggers") that occur when a BATCH - not a record - is
*completed*. There might be an appreciable difference.

I hope that id batch processing stamps records with a date time after the
last transaction updates, that none of the new information was viewable
until the transaction completes. That puts the onus on the creator of the
transaction to make those transactions fast, because data is technically out
of date all the while a transaction is completing.

I cannot believe there would be any utility to a process which puts a
timestamp of A on a record that is still viewable at some time past A, still
in its non-updated condition, only to reflect the most up to date
information slightly later.

Essentially, doing things the way that senior developer told me to, that was
clearly a risk that I ran.

I'll bet huge sections of courses covering transactions, EDI, whatever, have
been written on this stuff?

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Friday, August 22, 2014 9:09 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] New thrd: dates

Hi Bill

You would rely on dtStamp being a date/time value. The field would be of
data type Date.

The records would be stamped identically with the value of dtStamp.
If you want the real time as close as possible, for example in a loop of
long duration in VBA, you would call Now within the loop for each insertion.

/gustav



More information about the AccessD mailing list