Library functions in Access 2003

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
 
A

Allen Browne

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Urgent Strang error (2003 - 2007 ) 4
using excel functions in access 1
Module functions can't be found, but only on one computer 2
RTD wrapper functions do not work in Excel 2007 4
Compile errors in Access 2003 1
built-in functions 1
Problems With Functions in Access 2002 12
DDE Send functions from Access 2003 not working in Access 2007 0

Top