File Creation Date, How to access in Access

[Dennis]

Access 2003

In Excel VBA there is a function or property:

ThisWorkbook.BuiltinDocumentProperties("Author")
and
ThisWorkbook.BuiltinDocumentProperties("Creation Date")

In Access, what are the comparable VBA Statements?

I have been attempting to use:

CurrentProject.BuiltinDocumentProperties("Author")

But to no avail.

How can this be done with VBA for Access?

TIA Dennis

 

[M.L. Sco Scofield]

The FSO works great. You can get created, modified, and accessed date/time.

That's what I use at the bottom of my web site pages like http://www.scobiz.com/Calendar.asp and
http://www.scobiz.com/Presentations.asp.

You need to set a reference to "Microsoft Scripting Runtime" in VBA or use late binding.

For time's sake, I just copied the VBScript from my ASP. (It uses late binding.) You shouldn't have any problem cleaning it up for
VBA.

Set objFSO = CreateObject("Scripting.FileSystemObject")

Set objFile = objFSO.GetFile(Server.MapPath("Presentations.asp"))
datDateCreatedASP = objFile.DateCreated
datDateLastModifiedASP = objFile.DateLastModified
datDateLastAccessedASP = objFile.DateLastAccessed

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com