We are excited to announce that the ASP.NET Forums are moving to the new Microsoft Q&A experience. Learn more >
Custom mdb Function not working in aspx [Answered]
1 reply
Last post Feb 17, 2013 04:28 AM by Mikesdotnetting
Last post Feb 17, 2013 04:28 AM by Mikesdotnetting
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
194868 Points
28100 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).