How to debug a Bad DLL calling convention error in MSAccess VBA code

Question

Hi,

The title says it all I made some changes to a function in a module and then got the error. How do a debug it to find the cause?

The error occurs on the Exit function statement of the function...great hey!

Malcolm

Answer 1

Have you checked your references and decompiled?

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" 
                                "d:\My Documents\access\mayapp.mdb" /decompile

See also: http://www.granite.ab.ca/access/decompile.htm

Answer 2

I've just got this in Excel and wondered if anyone else have gotten it previously. My solution was to move around the references to my own DLL and click 'Compile <Project>'.