Database creation date

[David C]

How do I find the DateCreated for a MSAccess mdb file?

- and is this a fixed value, or does it get changed, eg when the file is
copied via CD to another drive?
- I have the path and filename of the mdb as a string.

I am using MSAccess2003

 

[Stuart McCall]

How do I find the DateCreated for a MSAccess mdb file?

- and is this a fixed value, or does it get changed, eg when the file is
copied via CD to another drive?
- I have the path and filename of the mdb as a string.

I am using MSAccess2003

This module will do what you want:

http://www.smccall.demon.co.uk/MiscApi.htm#FileDateTime

Debug.Print ReadFileTime("c:\temp\test.mdb", ftCreationtime)

And no, the creation time shouldn't be modified by copying.

HTH