Access 2003 Runtime Error with Runtime - Function not available in expressions

Posted on 2007-10-01
Last Modified: 2008-12-17
Hi Folks,
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

Question by:fturner64119
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    *Typically* ... this error would occur if you do not have a reference to DAO ...  which is the case when you create a brand new mdb.  However, seems this should not be an issue with the RT.

    LVL 48

    Accepted Solution

    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)

    What was the exact resolution - per the possibilities mention in the KB ... for your case?


    Author Comment

    Oh man, has this one been a trip!
    tks DatabaseMX but I did have a DAO reference already.
    tks jpauline, you lead me down a path that really help out on this one.
    The article you pointed  me to had a lot to sy about references. Like, uncheck them, Compile, do a Compact and repair, leave the program, reenter the program and reset the references. After I did this I still had problems, I put the references in a different order. Now I'm seeing light ! But the real deal came when I did NOT make a .mde and used the package wizard with the .mdb. Big Change. The code started runing a bit and then pooped out. It wanted some files it could not find. Don't ask me why, I though the wizard was supposed to add all necessay files.
    In my case the files where MSADO27.tbl  --  MSOUTL.OLB  and MSWORD.olb. So, I simply added these files in the wizard setup (add files), set it to my newered PC and bingo. These files where in \WINNT\SYSTEM32.
    I reckon it's a done deal. Let ya'all know how it goes in with the clients.
    tks  fturner64119

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now