473,394 Members | 1,541 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

'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 2712

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...
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) &...
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...
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...
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...
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...
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...
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...
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...
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
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...
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,...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

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.