J
jkrukonis
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.
Also, if using Runtime 2007 on a v2003 .MDE gives the "Function is not
available in expressions in query expressions (Function Expression)" error.
When running against the save database v2003 .MDB file, all is well.
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? Or how
to correct the v2003 .mde/.mdb issue?
Thanks
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.
Also, if using Runtime 2007 on a v2003 .MDE gives the "Function is not
available in expressions in query expressions (Function Expression)" error.
When running against the save database v2003 .MDB file, all is well.
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? Or how
to correct the v2003 .mde/.mdb issue?
Thanks