The expression you entered has a function that microsoft access

[saputros]

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!!

 

[mwolf00]

Maybe it can't find the macro which is located on the server. Perhaps you need more path information? I've never done something like this, but if it works fine on the server but not the network, maybe IIS is trying to locate the macro on the client machine (weird!). Let us know what you find out... Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048

mikewolf@tst-us.com

 

[saputros]

Actually, I think it's some kind of permission problem. Yesterday I tried giving a particular user an "administrator" right, then it worked fine. But when I have the user login as IUSR_MachineName, then give IUSR_MachineName rights to the folder, files, db, and access/lauch permissions (dcomcnfg), it still doesn't work.

Obviously I can't give everyone 'administrator' access, so I have to find where exactly does the user need the permission. Any ideas?

Thx!

 

[mwolf00]

I have a feeling that the 'Application.DoCmd' is what needs the permission - and you don't want anonymous users to have control of that!!!!! Can you execute the macro another way? Perhaps the command object?

Look at this link on running access macros in asp:

http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=251

http://www.aspfree.com/authors/robert/Default.asp?aid=17

Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048

mikewolf@tst-us.com

 

[saputros]

I tried using AccessObject.Run "name" as suggested by aspfree.com, but the same problem. The error message was different, it says "exception thrown by server", but I think it's the same problem as doCmd...