Database creation date

  • Thread starter Thread starter David C
  • Start date Start date
D

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
 
David C said:
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
Click to expand...

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
 
Back
Top