MS Access - Undefined function 'Dir' in query expression

by Bill Beckelman 1/6/2008 4:21:00 PM

I was working on a project in MS Access this afternoon and kept getting a "Undefined function 'Dir' in query expression" error message whenever I opened certain forms that had worked fine in the past. I googled the error message and it didn't come up with much. Most everything I found pointed to a missing reference. However, when I opened up my references everything looked normal and none were marked as "Missing" as you often see with MS Access. Since I haven't worked in Access for a while, it took me quite a while to remember SandBox Mode. It dawned on me that I had not been seeing the Security Warning: Unsafe expressions are not blocked dialog on startup for a while. Sure enough SandBox mode was set too high and was blocking the expressions in my query from working. Changing the security level fixed the problem. For a good article explaining Sandbox mode and how to change it etc, see How to Avoid the Sandbox Storm

 

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , ,

MS Access

Related posts

Add comment


(Will show your Gravatar icon)  

  Country flag

[b][/b] - [i][/i] - [u][/u]- [quote][/quote]



Live preview

8/21/2008 11:51:11 AM



Powered by BlogEngine.NET 1.3.0.29
Theme by Mads Kristensen

About the author

Name of author Bill Beckelman
I live and work in South Jordan, Utah

E-mail me Send mail

Calendar

<<  August 2008  >>
MoTuWeThFrSaSu
28293031123
45678910
11121314151617
18192021222324
25262728293031
1234567

View posts in large calendar

Pages

    Recent comments

    Disclaimer

    The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

    © Copyright 2008

    Sign in