- Local time
- Tomorrow, 07:06
- Joined
- Jan 20, 2009
- Messages
- 12,851
Does anyone have a reference with a definitive list of the Jet/ACE engine functions?
Following up from this thread it seems some developers don't realise the standard functions used in queries are NOT the VBA functions that have the same names, but are integral to the engine itself.
I tried to find a list and posted a link to a page that had been posted by someone having a similar discussion but it isn't right. (Shouldn't have taken it on face value.) I have looked again but I can't find anything.
I guess it could be determined by sending queries via ODBC and seeing what works but that seems a lot of effort.
Following up from this thread it seems some developers don't realise the standard functions used in queries are NOT the VBA functions that have the same names, but are integral to the engine itself.
I tried to find a list and posted a link to a page that had been posted by someone having a similar discussion but it isn't right. (Shouldn't have taken it on face value.) I have looked again but I can't find anything.
I guess it could be determined by sending queries via ODBC and seeing what works but that seems a lot of effort.