Access 2003

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

Andy Cap

Afternoon all,
I've an MS Access application that's been running for ever (5 or 6 years)
without any problems until recently when I had a persistent DB crash. The DB
crash I solved with a full reinstall of Access 03.

But now any SQL statements using "right" or "left" or "mid" are causing a
run time error 3075. Full error text is as follows "Function is not available
in expressions in query expression 'Right([First number],Val(Len([First
number])-3))'".

There have been no code or SQL line changes. Below is a sample of one of the
DoCmd's in question....

DoCmd.RunSQL "UPDATE tblDataLoad SET tblDataLoad.[Number] = Right([First
number],Val(Len([First number])-3)) WHERE (((Left([First
Number],3))='353'));", -1

It's as if the "left" and "right" etc are no longer valid!

Any ideas or suggestions would be very much appreciated.

Thanks
 
Andy said:
I've an MS Access application that's been running for ever (5 or 6 years)
without any problems until recently when I had a persistent DB crash. The DB
crash I solved with a full reinstall of Access 03.

But now any SQL statements using "right" or "left" or "mid" are causing a
run time error 3075. Full error text is as follows "Function is not available
in expressions in query expression 'Right([First number],Val(Len([First
number])-3))'".

There have been no code or SQL line changes. Below is a sample of one of the
DoCmd's in question....
Click to expand...


It sounds like you lost a library during the reinstall.
Check the db's References to make sure all the libraries are
still in their proper folders. Even if they are, you might
have picked up a different version, in which case the
reference needs to be reselected.
 
Back
Top