microsoft.public.access

Here's more info. Runtime 2007 also gives the "Function is not
> available in expressions in query expressions (Function Expression)" error when running a Version 2003 .MDE file. If Running against the 2003 .MDB file, all is well.

"J Krukonis" wrote:

> I have a 2003 database that has been converted to 2007 and all code compiled.
> All references are intact. It is fully functional as an .ACCDB using both
> access 2007 and runtime 2007.
>
> When converted to an ACCDE, the following errors appear: Function is not
> available in expressions in query expressions (Function Expression). Both in
> Access 2007 and runtime 2007.
>
> If I build a package and install as an .ACCDR, all functionality is
> restored. Since this application is constantly changing and is used by a
> multitude of people this deployment is not possible.
>
> Does anyone know how to create an .ACCDR without going through the package
> deployment process? or How to resolve the issue with an .ACCDE file?
>
> Thanks
>