Solved

Unknown Jet Error in Query with User Defined Function

Posted on 2011-02-23
3
661 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: 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!

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

739 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