MS Access 2003 running 64 bit system problem

[stan_the_man21ph]

Hello, I have this problem with an application that I am supporting. The scenario is that I have a ms access 2003 application in a 64 bit windows 2008system or windows server 2003. The problem is that I have a function that needs to be called when I execute a query object, ex: when I open the query object by clicking the design button I have this query string"select funcGetCode(dummy) as column1, description from temptable" This funcGetCode() is from a reference dll file of the mdb proj. The problem is that when I try to execute it(debugging through ms access), an error will be reported wherein it states that"Undefined function 'funcGetCode' in expression. Meaning it was not able to find the function. On a 32-bit system all is ok without modifying the mdb.Any help is much appreciated.Thanks,Stan S.

[rpeare]

what is the code of the function? Is it possible to recode it so it's acceptable to either system?

[stan_the_man21ph]

Hello rpeare,

Thanks for replying, actually the function that can't be called from a query was on a reference module. What I did was just to make another copy of that same function on a module of the main access db file and not the reference .mda file and it already works for 64 bit. Just wondering what would probably be the issue here since it works with 32 bit systems? Is this probably a security issue?

[ajetrumpet]

why would the bit configuration of the OS be related to calling a vba function from a query? Is that what you're saying? I'm curious about it.

Undefined function, in my eyes, could mean:

1) you have a broken lib reference in vba.
2) the function changed names or is misspelled.
3) the function is really a subroutine.

what do you mean by this:

This funcGetCode() is from a reference dll file of the mdb proj.

I don't get that. The function you're trying to call is INSIDE the dll? Or you just have a ref to the dll that is somehow being used in the vba function?