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" <(E-Mail Removed)> wrote in message
news:67546809-0EC6-4762-A9F8-(E-Mail Removed)...
> 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