Access 2010 - FileDateTime Function returns #Name?

Question

I have a Access 2003 database that uses the FileDateTime function.  When I open the database in 2003 the function works perfect.  However, when I open the database in 2010 I get #Name? as the result.

When I look in the Expression builder, I do not see this function in the list of All Functions.  But I see a website that says that it works in 2010.

Am I missing the reference to the library with this function?  What Library contains the function?

FYI - I am testing this with a file on my C:\ drive so I know I have access to the file.

Please help.

Thanks,

Terry

Answer 1

In recent versions of Access, you can't use FileDateTime directly in an expression, it is considered to be "unsafe". You can use it in VBA code though.

You could create a custom function to act as "wrapper":

Function GetFileDateTime(FileName As String) As Variant

    On Error GoTo ErrHandler

    GetFileDateTime = FileDateTime(FileName)

    Exit Function

ErrHandler:

    ' Something went wrong, return Null

    GetFileDateTime = Null

End Function

and use it like this in an expression:

=GetFileDateTime("C:\Access\MyDatabase.mdb")

Alternatively, you can fill a text box using code, for example:

Me.txtFileDate = FileDateTime("C:\Access\MyDatabase.mdb")

Answer 2

Thank you, Hans.

Answer 3

I don't know of a list specifically for Access 2010, but as far as I know the information in http://support.microsoft.com//kb/294698/en-us still applies.

Answer 4

Hans - would you know of a list of similar "unsafe" native functions in Access 2010? It would be something rather important to have.

Answer 5

Excellent!! Worked Perfect. Thank you!!