The content of the vba function triggered is not the problem, it works fine when triggered through manual inserting a record. Only when trying to do this with an external application the error occurs, even when a test function contains no code at all.
I'm starting to think it has to do with permissions (window user/uac level) or such.
The ultimate thing I am trying to do here is not even the insert itself, that was just to bridge and trigger the trigger
What I am really trying to do is to get an external application directly trigger a vba function in the Access database, while passing two parameters.
This function does a lot: copy a table, creating and populating an excel file, and email it.