Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1138
  • Last Modified:

Error 3085: Undefined functions 'Nz' in expression

Experts,

I have developed an application in Access 2003.  It quite large an in the final stages of development.  The application is to be distributed with the SageKeys Access 2003 MSI wizard (which is very good).  The install works perfect but I have discovered that when installed on to a Microsoft Vista Machine the application throws the error: Error 3085 - Undefined functions'Nz' in expression.

I use the Nz function extensively throughout the program.  In queries, forms, reports and modules.  On the vista machine the program does not crash, but nothing displays on the forms because of this error.

My question/s:
1. Does anyone know why the Nz funciton is not found on the installation?
2. Can I fix it without recoding every occurance to iif and isnull statements?

Thanks
 
0
Carl Sudholz
Asked:
Carl Sudholz
  • 4
  • 3
1 Solution
 
Kelvin SparksCommented:
It usually means one library cannot be found or you have a broken reference. Are you running a full copy (mdb) and able to check these?
0
 
orcicCommented:
This could happen if you miss some reference or if your code would not compile.
Try to do the following.
Open your access code and go to the Tools->References. Check if there is any MISSING registration. After that go to Debug->Compile...
Hope this helps....
0
 
Carl SudholzManaging DirectorAuthor Commented:
Kelvinsparks--> The applications is to be distributed to machines with access runtime only.  I can check references by code, I will try that and get back to you.

Orcic  --> I am unable to check the references using the references dialog as the application will be running in runtime only.  Users will not necessary have access 2003 installed on their machine.  The references are all good in the original application.  It is only on the install on with Vista that I have experienced this problem.

Thanks
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
Kelvin SparksCommented:
Are you using the version of SageKey that is made for Vista? I use the 2002 version and had to buy an update so it would work with Vista. The way Vista handles things needs all sorts of directory changes.

I suspect you will be registering some dependant files in addition to the database (extra dlls or similar).

0
 
Carl SudholzManaging DirectorAuthor Commented:
Yep, got the latest SageKey Wizard (version 2.1.2.20). They tell me it works for Vista.  The install works fine.  Its the applicaiton during run time that doesn't. Know doubt it has something to do with references.  
I am using the Sagekey wizard to installing the Access runtime, jet 4.0 sp8 and MDAC. My application uses just the standard libraries:
Mircosoft Access (msacc.olb)  - Installed with runtime (I understand)
VBA (vbe6.dll) - Installed with runtime (I understand)
DAO 3.6 (dao360.dll) - Installed with Jet 4.0 (I understand)

To my understanding these standard libraries are installed with the Sagekey installer.
0
 
Kelvin SparksCommented:
If I recall correctly, there's a correct folder for installing to Vista - you may need to reread the Sagekey site for details, as the the old Program Files doesn't work as it should. Sagekey wraps the database as it's own application to keep it away from anything else. As such, you have to make it live within the Vista environment.
0
 
Carl SudholzManaging DirectorAuthor Commented:
Thank kelvinsparks for your input.

Turns out I was quite easily able to remove the need for all libraries except the core one for access (Access, VBA, and DOA).  This has solve the issue and my application now installs fine.  Distributing not standard libraries with Access is to prone to problems i think.
0
 
Kelvin SparksCommented:
Yes, if they are non standard, SageKey doesn't always detect them and you have to tell Sagekey to add them and where to store/register them. It is quite happy then.
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now