I want to call a sub of the module created in a ms access database.
I could not call it right away so I created a macro which does "RunCode" and I put the name of the sub,but this code would not work in ASP.I can run other macros from ASP but I can not run this one,the error I get is:

MSAccess error '800a0979'
The expression you entered has a function name that Microsoft Access can't find.

my code is here:
Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase "C:\database1.mdb"

'this does not work
'objAccess.Call CreateLMSPortfolio("Luke", False, "5", "Pack", "Jmac", "RTI")

'so I run a macro
objAccess.DoCmd.RunMacro "Macro1"
Does anybody have a solution for this?