Solved

Unknown Jet Error in Query with User Defined Function

Posted on 2011-02-23
3
653 Views
Last Modified: 2013-11-27
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
Comment
Question by:shacho
  • 2
3 Comments
 

Author Comment

by:shacho
ID: 34966709
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
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 34967113
Pretty strange. Almost seems like some kind of corruption.  Have you tried a .... just kidding !
0
 

Author Comment

by:shacho
ID: 34976164
Yeah.  Probably you're right.  Happens sometimes.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now