Problems with "Unknown function name" using Access module

[Jacob Hojnacki]

I have problem with message "Unknown function name"
during using my own (defined as "public" in module)
function in Access query (expression constructor shows
this function in Functions -> MyDb1 -> ...).
When I pass some value into this function, I have no
message, but "#Error" value in query column.
Reinstallation of MS Office didn't solve this problem.

I'm using MS Windows XP SP1 with MS Office 2000 SP3.

On other computer with the same system & Office
configuration everything is working fine.

Help me, please, what it could be...
Thank You in advance.
Jacob

 

[John Vinson]

I have problem with message "Unknown function name"
during using my own (defined as "public" in module)
function in Access query (expression constructor shows
this function in Functions -> MyDb1 -> ...).
When I pass some value into this function, I have no
message, but "#Error" value in query column.

I'd suggest (in escalating order): you've almost surely done the first
couple, but I'm including them for completeness.

- Opening the VBA editor and selecting Debug... Compile <mydatabase>
and fix any compilation errors.
- Compact the database.
- Make a BACKUP! TEST THE BACKUP! and Decompile the database: see
http://www.granite.ab.ca/access/decompile.htm for a discussion and
instructions. Then Compact again, open VBA, compile, and compact yet
once more.
- If the above fails, create a new, empty database and use File... Get
External Data... Import to import everything. This will give you a
clean set of systems tables and can fix some such wierd problems.