[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Unknown Jet Error in Query with User Defined Function

Posted on 2011-02-23
3
Medium Priority
?
666 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 2000 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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

590 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