Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Undefined Function "DIR" in expression?

Status
Not open for further replies.

xhonzi

Programmer
Jul 29, 2003
196
US
So, I just copied an Access 2003 DB to a new computer running Access 2007. Everything seems to have converted over okay except for any of my queries running 'Dir'. I get the error, 'Undefined Function "DIR" in expression' whenever I try to run the query.

Is there a different syntax or something I need for 2007? My google search didn't come up with much besides, "Maybe reinstall everything?"

Any ideas?
 
Okay, so better googling for better living.

Turns out the one sandbox reg key was set to 2, but the one at HKEY_LOCAL_MACHINE\Software\Microsoft\Office\12.0\Access Connectivity Engine\Engines was set to 3. It was blocking certain "unsafe" functions like "dir". Set it to 2 and I'm back in business.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top