Undefined function 'Left' in expression

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

After upgrading to Windows 2000 from 98, I got the
following error message:

"Undefined function 'Left' in expression" when trying to
run a query and a form that relies on that expression.
This query and form work fine on all the other systems on
the network, except for on the one I upgraded.

Suggestions?
 
Andy said:
After upgrading to Windows 2000 from 98, I got the
following error message:

"Undefined function 'Left' in expression" when trying to
run a query and a form that relies on that expression.
This query and form work fine on all the other systems on
the network, except for on the one I upgraded.

Suggestions?
Click to expand...

Often when databases don't work on one particular machine, it's because
of a broken or missing reference, and your recent upgrade makes that
seem a likely explanation. See if the steps outlined here help:


http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Undefined function Left in expression 2
undefined function? 1
Access #Error & Excel Pivot 0
left$ 1
date() in query undefined 5
Query error: Undefined function 'Concatenate' in expression 3
Function issue 4
Error message UNDEFINED FUNCTION 6

Back
Top