Last post Feb 17, 2013 04:28 AM by Mikesdotnetting
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
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).