locked
Custom mdb Function not working in aspx RRS feed

  • Question

  • User-775831949 posted

    I have an aspx with AccessDatasource connecting to mdb working fine displaying Gridview.

    Now, I added a user defined function within mdb and use it in a query within mdb and when I click that query in mdb it is displaying desired result (ie one field use user defined function.)

    However, now the aspx page onrun, display undefined function 'Myfunction' in expression.

    I dunno why in mdb it runs correctly why in aspx it failed. Pls help, thanks

    Sunday, February 17, 2013 1:47 AM

Answers

  • User-821857111 posted

    Custom functions like that can only be executed within the Access application. When you use an .mdb file as a data source in ASP.NET, you are no longer executing an Access application. You are using a JET database and they do not support custom functions (or half of the Access built in functions either).

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, February 17, 2013 4:28 AM