none
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.
    Wednesday, January 25, 2012 5:31 PM

Answers

All replies

  • 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.


    I believe that's one of the functions deemed "unsafe", and so it's disabled in queries when the database engine is running in sandbox mode, which is the default.  See this link for how to disable sandbox mode:

    http://office.microsoft.com/en-us/access-help/introduction-to-access-2010-security-HA010341741.aspx#_Toc265079117

     


    Dirk Goldgar, MS Access MVP
    Access tips: www.datagnostics.com/tips.html
    Wednesday, January 25, 2012 7:11 PM
  • Is the database in a Trusted location? If not, most of the code (including functions) won't run. Either set the folder as a trusted location under Options>Trust Center or set your macro security (same place) to its lowest setting.
    Bill Mosca
    http://www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals
    Wednesday, January 25, 2012 8:57 PM
  • Also see Access 2010 - FileDateTime Function returns #Name? in the MS Answers forums.
    Regards, Hans Vogelaar
    • Marked as answer by TE2011 Wednesday, January 25, 2012 10:04 PM
    Wednesday, January 25, 2012 9:01 PM
  • The Response you provided in the link was perfect.  Thank you!!
    Wednesday, January 25, 2012 10:05 PM