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
Thanks. I will try to credit the ones who helped but most important is we really do sincerely thanks to all who have helped.
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).
Participant
753 Points
2406 Posts
Custom mdb Function not working in aspx
Feb 17, 2013 01:47 AM|hkbeer|LINK
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
www.developerfusion.com/tools/convert/csharp-to-vb/
All-Star
193101 Points
27952 Posts
Moderator
Re: Custom mdb Function not working in aspx
Feb 17, 2013 04:28 AM|Mikesdotnetting|LINK
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).