Discussion Locked

MS Access Module not found

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to update a SQL database using Access. The module I wrote is parsing a string and adding to the string on the left. For some reason when I run the update query, the query does not find the module I wrote to do the string manipulation. What do I need to do to get the update query to recognize the module?

3 replies

by glen_mcleod

If I understand you question right, you're calling a user defined function from your update query.

I've done this many times and the main thing you have to do is make your function public. If it's already public, set a breakpoint and step through the code, you may find an unexpected error that is causing your function to exit prematurely.

Glen

by holddedoor

The problem ended up being that I had a module declared with the same name as the function and Access didn't know which one I wanted.

This discussion is closed to new replies.