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

[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

 

[Douglas J. Steele]

See whether the "Quick Solution" in
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html helps.

 

[Tony Toews [MVP]]

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

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