Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 665
  • Last Modified:

Unknown Jet Error in Query with User Defined Function

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
    MyUdfVal="a"
End Function
and it still fails.

Any ideas?

Cheers,

Mike

PS - Please don't ask me to compact and repair. ;>


0
shacho
Asked:
shacho
  • 2
1 Solution
 
shachoAuthor Commented:
I just tried renaming the function.  That failed.
Then I tried creating a new function with yet another name, and moved the internal code. That worked!
So what's happening behind the scenes and how can I prevent this?

Mike
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Pretty strange. Almost seems like some kind of corruption.  Have you tried a .... just kidding !
0
 
shachoAuthor Commented:
Yeah.  Probably you're right.  Happens sometimes.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now