Unknown Jet Error in Query with User Defined Function
Posted on 2011-02-23
This was working until recently. Not sure what's changed.
In an update query I have one field that references a user defined function.
The function returns a string, and the field is a string with a size larger than any value the function could return.
When I try to run the query, Access says "Unknown Jet Error".
I've pared the function down to something like this:
Public Function MyUdfVal() As String
and it still fails.
PS - Please don't ask me to compact and repair. ;>