Odd issue with file Created Date

[moke123]

I have a temp database, a/k/a side database, that I use for temp tables.
I was toying with the idea of deleting and re-creating the temp database periodically.
To do this I figured I'd use the created date of the Temp database and if it were older than a certain period of time delete and re-create it.

On my home computer, win 11 home & office 365, when I would delete and re-create the temp db it would retain the old created date from the deleted file.
It is clearly a new file but bears the old date. I've tried numerous different things like refreshing tableDefs, etc. but nothing changes this behavior.

On my office computer, win 10 pro & office 365, when I re-create the temp db it does have a new created date as expected.



I've attached a db to demonstrate how I process the temp db. This includes a procedure to reset the created date to an earlier time.

Any thoughts or ideas on why this occurs?

[Minty]

Have you tried renaming the old one, creating a new one then deleting the old (renamed) one?
I think this is something to do with a helpful tracking (file history?) function in Win11.

I'm afraid I can't test as my Win 11 laptop (spare) is currently on holiday with my daughter enjoying her normal one being broken.

[Micron]

Are you referring to file properties as seen in Windows or properties of the database object?
WRT file properties, we saw this behaviour years ago when attempting to use file date properties to id files by file date properties. IIRC, modified dates could even be older than create dates so we abandoned the idea.

[moke123]

I think this is something to do with a helpful tracking (file history?) function in Win11.

File history is turned off on both machines(by default)

Have you tried renaming the old one, creating a new one then deleting the old (renamed) one?

I'll give this a shot when I get home tonight.

Edit: Remoted to home machine and the name change appears to work.
May be an easier work around rather than changing the created date via code. The code to change the created date takes up 2 modules.

[moke123]

Unfortunately rename and delete didn't work.

I didn't see anything that jumps out at me in the hidden and system tables.
It does appear that any tables added to the temp database remain in MySysNameMap table.

[moke123]

Are you referring to file properties as seen in Windows or properties of the database object?
WRT file properties, we saw this behaviour years ago when attempting to use file date properties to id files by file date properties. IIRC, modified dates could even be older than create dates so we abandoned the idea.

Weird, this didn't show up until now.

WRT? windows runtime?

I believe the code I'm using from Chip Pearson uses windows API's to read and write to the file properties.

The odd thing is how it works correctly on work computer and not on home computer.

[Micron]

With Respect To
or
in regards to, or re:

[moke123]

With Respect To
or
in regards to, or re:

Ah ok, you kids and your acronyms

[Micron]

I'm no kid. Lots of candles on my birthday cakes now. That is, IIRC.

[moke123]

i'm no kid. Lots of candles on my birthday cakes now. That is, iirc.

ikt, lol

[Minty]

Unfortunately rename and delete didn't work.

I didn't see anything that jumps out at me in the hidden and system tables.
It does appear that any tables added to the temp database remain in MySysNameMap table.

Once removed if you compact and repair the Side DB do they disappear?
You could set a side DB to compact on close?

[moke123]

I found a work around which is probably better than my original thoughts on this, but I'd still like to know why the differences on the 2 machines.

My work around is to set a custom property for the temp database when created.
Then I can just test whether Date > the custom property.

    Dim p As Property
    Set p = TDB.CreateProperty("Expiry", dbDate, DateAdd("d", 30, Date))
    TDB.Properties.Append p

[Micron]

My work around is to set a custom property for the temp database when created.
Then I can just test whether Date > the custom property.

I wonder who or what planted that idea seed?

Are you referring to file properties as seen in Windows or properties of the database object?

[moke123]

Attached Demo of what I came up with.

I wonder who or what planted that idea seed?

I'm no kid. Lots of candles on my birthday cakes now. That is, IIRC.

Not bad for an old guy