Library functions in Access 2003

  • Thread starter Thread starter MacDermott
  • Start date Start date
M

MacDermott

A client and I both have Access 2003 SP3 running on Windows XP SP2.

When I use the built-in functions FileDateTime and FileLen in Queries, they
run fine.
When he uses them in Queries, he gets an "unknown function" error.
He can use those functions in code,
And if he writes a custom wrapper function in a public module, he can
call these from a query.

I seem to recall this problem when the functions InStrRev(), Split(), Join()
and one other were introduced -
back in A2K, or was it even in early A97?

Can anyone shed any light on why the wrapper functions are necessary on my
client's PC, but not on mine?

TIA
- Turtle
 
Tuttle, could the difference be Sandbox mode?

You probably set your Macro Security (Tools menu) to Low, and allowed JET to
run 'unsafe expressions.' I'm guessing your client has different settings.

This kb might help him disable Sandbox mode:
http://support.microsoft.com/kb/294698
 
Back
Top