[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2007-10-01
4
Medium Priority
?
1,302 Views
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


0
Comment
Question by:fturner64119
  • 2
4 Comments
 
LVL 75
ID: 19992491
*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.

mx
0
 
LVL 48

Accepted Solution

by:
jpaulino earned 1500 total points
ID: 19992522
0
 
LVL 75
ID: 19994639
turner64119

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

mx
0
 

Author Comment

by:fturner64119
ID: 19994815
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
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

872 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