I got the following error that I have been struggling with for a while now: The expression you entered has a function that microsoft access can't find.
What I tried to do was to call a Microsoft Access Macro from ASP, and in turn this macro calls a function in a module.
The thing is, these codes work perfectly fine when I run it on the server, but fails when I run it from the network (on other computers).
The module is a standard module with only one function. The ASP calls use 'Application.DoCmd.RunMacro "macroname"' to call the macro.
I'm running IIS w/ SP1, Office 2000.
Any help would be much appreciated!!
What I tried to do was to call a Microsoft Access Macro from ASP, and in turn this macro calls a function in a module.
The thing is, these codes work perfectly fine when I run it on the server, but fails when I run it from the network (on other computers).
The module is a standard module with only one function. The ASP calls use 'Application.DoCmd.RunMacro "macroname"' to call the macro.
I'm running IIS w/ SP1, Office 2000.
Any help would be much appreciated!!