Database Properties : Date Created vs DateCreated

Dear All,

I was trying to get my database propeties using VBA Code as follow :

Dim fs, f, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile("FileName")
zDateCreated = f.DateCreated
zDateModified = f.dateLastModified

MsgBox Created : & zDateCreated & " Modified : " & zDateModified

It works fine, but the result of Msgbox makes me curious why zDateCreated and
zDateModified is not the same when I check through File > Database Properties
General ?

1. In the MsgBox shows (yy/mm/dd hh:nn:ss) :
Created : 06/12/07 10:21:44 Modified : 06/12/07 10:22:00

2. In File > Database Properties > General (yy/mm/dd hh:nn:ss)
shows:
Created : 07/01/06 02:43:02 Modified : 07/01/05 22:48:16

Please someone tell me why? How can I get (through VBA Code) the same
Database Properties when I click File > Database Properties > General?

Thanks,
Tintin

.

Relevant Pages

  • RE: I didnt think of this
    ... Private Sub Form_Open ... Dim myDB As DAO.Database ... defined database properties to control it. ... When the user first opens the database, ...
    (microsoft.public.access.formscoding)
  • Re: db repair
    ... Server. ... VB Script looks amazingly like VBA, since they're both based upon the same ... See http://www.mvps.org/access/general/gen0041.htm for the VBA code to ... this won't compact the database ...
    (microsoft.public.access.setupconfig)
  • Sending Word bookmarks to Access
    ... I have built an Accessdatabase which was converted to 2003 and an ... Access form to send out assignments. ... The form has VBA code to send the ... Macros on the Word document are also gone. ...
    (microsoft.public.word.vba.general)
  • Conv Access 97->2000-Gets a method or data member not found error
    ... needed in the VBA code. ... >>Dim dbCurrent As Database, dbSecurity As Database, rs As ... >>Dim TempPw As String, tempID As String ...
    (microsoft.public.access.conversion)
  • Re: Crosstab query and report
    ... I download your example database called CrossTab.mdb. ... >> report I am using. ... It also contains some VBA code which I do understand. ... >> Duane, If I remove the where clause, the report runs great. ...
    (microsoft.public.access.reports)