As I understand it, Achim, the functions that are available in Jet SQL when
executed outside of the Microsoft Access environment are the functions
supported by the Jet expression service. If it's not supported by the Jet
expression service then, to the best of my knowledge, there is no way to use
it in Jet SQL outside of Microsoft Access.
At my blog (URL below in my sig line) I'm working my way in alphabetical
order through the list of built-in VBA functions to find out which ones can
be used outside of the Microsoft Access environment. I'm only up to
functions beginning with 'P', and haven't updated it recently, but I'll try
to do some catching-up this weekend.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
With T-SQL i could do this inside msql but for me the problem is i need it
in access
Achim,
This is more a T-SQL issue. I suggest you post your question to the SQL
Server newsgroup.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
message in my mdb i have included stored procs and views that uses functions
defined in vba.
now if i use this views via ado this functions cann't be used. the could
not be found.
why and how can i overcome this.
my target is, to create a stored proc that uses functions from external
dll's that i have designed. id mssql this is possible i think. but how to do
this in access
thanks achim
