Solved

Unknown Jet Error in Query with User Defined Function

Posted on 2011-02-23
3
658 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 - Microsoft MVP, Access and Data Platform) 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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 …

830 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