Same thing

[Steven]

I am just frustrated. I did not think anyone would
actually read what I wrote. I should have just reposted
the question without venting. I understand not actually
speaking with the person can create difficulties. I will
have to call MS and make an over the phone case or make an
internet case. My thinking was that since CurrentDB.Name
returned the directory and name there must be an easy
command I have overlooked to tell the date an mdb or mde
file was created or modified.

I did get a response from a different posting saying to
put it in a shared hidden directory. I did not know you
could open a mdb or mde in a hidden directory.

This is an incredible service. I must say that I probably
have spent approx $5,000 over the last 2 years on cases
with MS but that is really ok because I would not ever get
anywhere without all the services...especially this one.

Thanks and keep up the good work.

Steven.

 

[Tim Ferguson]

My thinking was that since CurrentDB.Name
returned the directory and name there must be an easy
command I have overlooked to tell the date an mdb or mde
file was created or modified.

Often the simple questions don't have simple answers.

You can use the Scripting.FileSystemObject -- the File object in its
heirarchy has DateCreated, DateLastAccessed, and DateLastModified
properties.

Try (this has _not_ been tested!!):-

Set fso = New Scripting.FileSystemObject

Set fil = fso.GetFile(CurrentDB().Name)

dt = fil.DateCreated

Debug.Print Format(dt, "dd/mm/yyyy")


Hope that helps


Tim F