473,836 Members | 2,114 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

'Undefined function Dlookup' error with Sagekey 'Access 2002 MsiWizard'


I develop my applications in Access 2002. My development system is
running Windows XP SP2 and I have Microsoft Office XP Developer.
Microsoft Office XP is at SP3.
I used Inno Setup (great product) to install my applications.
When the Access Runtime was needed on the system I simply ran
'accessrt.msi' from Microsoft Office Developer discs.
When another version of Access (other than Access 2002) was on the
system then I simply edited the shortcut so that my application will
open with Access Runtime 2002.
Everything worked great for about six years.
In the last couple of years most of my customers (those already
existing and the new ones) have migrated to Microsoft Access 2003 and
recently to Microsoft Access 2007.
To avoid possible problems I decided to use 'Access 2002 Msi' from
Sagekey. The main reason was that 'Access 2002 Msi Wizard' from
Sagekey was supposed to generate completely independent installs for
my Access aplications so I will not have to worry if my clients
install and uninstall different versions of Access on their systems.
I use from January 2008 'Access 2002 Msi Wizard' from Sagekey.
Since I begun using 'Access 2002 Msi Wizard' to create my install
packages on some computers (1 in 10) a unexpected error happened
( 'Error 3085 Undefined function 'Dlookup'...).
Most of these errors are thrown on computers where full Microsoft
Access 2003 or Microsoft Access 2007 is already installed.
When I start my application (same application) with full version of
Access the problem is gone.
I do use 'Dlookup' function in an append query in application but as I
said it works fine when I use the full version of Access whether it is
Access 2002 or Access 2003.
The computers where the error happens are running Windows XP SP 2.
I checked the references and everything is OK.
The problem take place erratically on a system. The application is
working great for days and then suddenly the error is thrown.
Sometimes if a user restarts the application the problem is gone.
Sometimes it doesn't happens at all. I cannot reproduce the error on
my test systems so I cannot further investigate. The same application
is installed on few hundreds computers and this behaviour is ocurring
only on those computers where I installed the aplication with the
install package generated by 'Sagekey 2002 Msi Wizard'. The install
package always installs my application, 'Access Runtime XP', 'SP3 for
Access Runtime XP' and only if necessary 'Jet 4.0 SP8' and 'MDAC

I suppose the problem is with the access runtime packaged with 'Access
2002 Msi Wizard' since I've never had this type of error in years. I
installed many hundreds times 'Access Runtime XP' directly with
'accessrt.msi' on many different systems with different versions of
Access and never ever had this type of error. The code which generates
this error (as I said I do use 'Dlookup' in an append query) has not
been modified for years and it has always worked without errors.

I send a few emails to folks at Sagekey but I keep getting errors
'Your message could not be delivered..'
The 'Knowledge base' at SageKey doesn't cover this topic. I search the
Internet and access user groups for a workaround to this error for
almost a month now to no avail.

Does anyone encountered this error? It has something to do with the
installation package generated with 'Access 2002 Msi Wizard'? Are
there any workarounds?

Thank you very much for your time.
Excuse my english please, is not my native language.

Best Regards,

Sebastian C.
Feb 28 '08 #1
0 2763

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Ronny Sigo | last post by:
Hello all, I already put the same question, only now I have more to tell ... Although I used this code before in the same routine (only the fieldname of the table differs) ___ at this point in the code I get the error "You canceled the previous operation" err msg. When clicking on Help I get a white screen. I haven't got the slightest idea what it means .... I pinned down that this error comes from the Dlookup function, because if I put...
by: paddy_nyr | last post by:
I converted an Access 97 db to Access 2002 db and I now get the following error message when I try and run a query. Thanks Here's my query. SELECT DISTINCTROW tblCo_Info.Co_id, & Chr(13) & Chr(10) & & IIf(Trim()<>"",Chr(13) & Chr(10) & ,"") & Chr(13) & Chr(10) & IIf(Trim()<>"",Trim() & ", ","") & & " " & AS
by: Adam Kramer | last post by:
I am trying to call a module function in an Access db and then open a report from a VB application. The problem I've found: I can't find a good way to call a function that accepts arguments. I need to pass arguments to set information that determines which information will appear in the report. Code Below: MY argument accepting function: Public Function SetCurrentIDs(PCaseID As String) 'Set the values if the pcase exists
by: Bob Darlington | last post by:
I am looking at buying Installshield 11 Professional and Sagekey Access 2002 Runtime Object to facilitate the distribution of my Access 2002 application (having despaired with the PDW). One of the key reasons for using SageKey (as I understand it) is to ensure that no conflicts occur with other versions of Access. In fact their website mentions Access 97 through 2002 in this regard. However, no mention is made regarding Access 2003. The...
by: brooks | last post by:
It seems that the Access 97 ADT and 2000 ODE installers can seriously mess up a customer's computer. Sagekey sells a script to prevent this (~$500) which runs on Wise/Installshield (~$500) for a combined cost of about $1,000. Are there any less expensive installers which handle Access problems/conflicts? Brooks
by: sara | last post by:
I am learning how to use simple functions to make my apps more powerful and efficient. On one screen, I want to populate field B: ItemDescription by looking up the ItemDescription in the Items Table. I would use the key to the Items Table from the selection the user made in the combo box. SO: User chooses an item from the combo box whose value is "3". I want to look up the ItemDescription of the Item with the Key "3" and show that...
by: Bod | last post by:
Hi Folks, I've produced an Access application that reads the users login name from their environmental settings and then acquires their full name and department from the "Startup" table, to display on their startup screen (Code shown below). While this works satisfactorily in Access 2002 on any windows platform, it falls down on Access 2003. When debugging I get , and have no idea why. The line Marked "***" is where the debugger pulls...
by: rmmahara | last post by:
Hi Folks, I've been reading these forums for a while and now I'm in desperate need of help, so I thought I'd post! Background: I'm creating a Service Dashboard to track my team's adherence to Service Levels. As part of this, I've set up a web page which pulls data from a query in Access 2003. The page shows which tickets we're working on, how long they've been open, the service level for each ticket etc. Since we're a 9-5, Monday to...
by: rleepac | last post by:
This is a little complicated but I'll do my best to explain. In my db I have a table called L_AgeCorrection which has the following fields: Age, Sex, Frequency, AgeValue This is a table used to assign an Age Correction value to hearing test results - since some degree of hearing loss naturally occurs with aging - OSHA lets us calculate that in before determining if the employee has an actual "significant" hearing loss. Anyway...I have my...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.