MODIFIED-Date in Tables

R

Rene Weise

Hallo NG,
if I change a Record in a table (in Access) , so the MODIFIED-Date will
also be changed.
But if I do this with sql update (without access) the date will not be
changed.

Is this a bug by me or what must I do to change the date of the table?

Thank you - rene
 
D

Douglas J. Steele

Are you talking about a Modified Date field that you've added to your table?

You'd have to update that field as well in your query.
 
R

Rene Weise

Hallo Doug,
thank you.
Are you talking about a Modified Date field that you've added to your
table?
Click to expand...
no!! I'm talking about then
DATE_MODIFIED -Property of the table (schema). - right mouse-klick -
properties

grettings from rene
 
D

Douglas J. Steele

That property doesn't indicate when a record was saved. It's supposed to
indicate the last time the table design was changed. However, it doesn't
even do that because of the fact that Access does an all-or-nothing save.
 
J

Jamie Collins

That property doesn't indicate when a record was saved. It's supposed to
indicate the last time the table design was changed. However, it doesn't
even do that because of the fact that Access does an all-or-nothing save.
Click to expand...

Interesting. Do you mean that if one table is modified then all
tables' DATE_MODIFIED values get updated to the current timestamp? By
'Access' do you mean the the Access engine (or Jet engine) or the
Access user interface or someting else? TIA.

Jamie.

--
 
D

Douglas J. Steele

Jamie Collins said:
Interesting. Do you mean that if one table is modified then all
tables' DATE_MODIFIED values get updated to the current timestamp? By
'Access' do you mean the the Access engine (or Jet engine) or the
Access user interface or someting else? TIA.
Click to expand...

To be honest, Jamie, I don't remember the exact nature of the Modified date
problem tables, only that it got broken with Access 2000, and hasn't been
fixed yet. I remember a discussion with other MVPs where it was suggested
that the culprit was the change to the Save method in the Access user
interface, but I can't find any reference to this anywhere.
 
J

Jamie Collins

To be honest, Jamie, I don't remember the exact nature of the Modified date
problem tables, only that it got broken with Access 2000, and hasn't been
fixed yet. I remember a discussion with other MVPs where it was suggested
that the culprit was the change to the Save method in the Access user
interface, but I can't find any reference to this anywhere.
Click to expand...

Fair enough. Thanks :)

Jamie.

--
 
Top