Access 2003 Runtime Error with Runtime - Function not available in expressions
Posted on 2007-10-01
Sometimes I just want to eat worms!
I am trying to use the Access 2003 runtime. I have a program that is
fully working in 2003 but when I install the runtime version onto a machine
that has no MS Access with O/S Win 2000 installed, I have multiple errors.
error --- "Function is not available in query expressions.
The function is format([event_date],"ddd")
This error occurs 30 times, as I used it alot in queries.
There are four other errors for simple functions I use in the 2003
program. Has anyone had similar errors or can anyone point me to a
site that is likely to look into Access 2003 Runtime bugs. Have tried
searching the Microsoft site without success. I cannot believe I am
the only one experiencing these problems.
Any help greatley appreciated