error 3075: functions such as CHR$ not working on Vista

  • Thread starter Thread starter Andy_B_UK
  • Start date Start date
A

Andy_B_UK

Hi there. I'm developping in Access 2007, database in 2003 format, and using
functions such as CHR, LEFT, and RIGHT, in queries. This all works fine for
Windows XP users, but in Vista, the same database causes runtime error 3075
"Function is not available in expressions in query expression..."

Strangely, if I build the same query from scratch in a new Access database
in Vista, everything is fine.

I expected this must be a missing reference, but they all seem to check out
fine.

This issue is now causing big problems as we now have some Vista users &
some XP users.

Any ideas anyone?
Thanks
Andy
 
Andy_B_UK said:
I expected this must be a missing reference, but they all seem to check out
fine.
Click to expand...

Run the following code and post back the results.

Sub ViewReferenceDetails()

Dim ref As Reference

For Each ref In Access.References
Debug.Print ref.Name & " - " & ref.Major & "." & ref.Minor & "
- " & ref.FullPath
Next ref

End Sub
 
Back
Top