Built-In Commands (TRIM, FORMAT, etc.) don't work on Access Runtime in XP

  • Thread starter Thread starter Denny W. Jones
  • Start date Start date
D

Denny W. Jones

I've got a database that is distributed with Access 2000 runtime and it
works great until it is installed on an XP computer. Certain built-in
commands like TRIM(), FORMAT() and DATE() don't work. I get "#NAME" errors
anytime one of these commands are used. If I take the TRIM() command out of
the equation it works as expected.

It might be important to mention that this is occurring only on reports - or
so it seems.

Any ideas? Has anybody else experienced this problem?
 
Denny:

This is 99% of the time going to occur if there's a broken reference of some
type in the database itself. Common culprits are a reference to
Utility.mda or WizLib.mda (which are not re-distributatble).
 
As it turned out, the problem was with a missing DAO350.dll file. XP doesn't
use this version. It uses DAO360.dll. To remedy it, I installed the 350
version on the XP machine and registered it.

To get to this point I opened the original non-MDE file, opened a code
window and looked at the references (CTRL-G). This showed me all of the
references that the database was expecting. I then looked on the XP machine
to determine which files were missing.

Hope this helps someone.

Denny
 
Back
Top