Rounddown

J

Jamie Collins

Douglas J. Steele said:
My understanding is that if you're attempting
to connect to a Jet database from outside of Access (eg. from VB, VC++, ASP,
etc.), you can't use any VBA functions in your queries at all, because
you're strictly going through the Jet Engine, which doesn't know about VBA
functions.
Click to expand...

Jet does indeed to seem to 'know' about most/all the VBA5 functions.
How it does this I don't know e.g. could be Jet comprises the relevant
dll, they were re-engineered specifically for Jet, etc.

Jamie.

--
 
D

David

OK, I have been trying to rectify a problem that seems relevant to
this thread. I am using access 200, don't ask why, that connect to a
sql server. When using VBA, I can use the lcase and like functions.
That is unless, I am using it to query the access tables (linked as
well as native). The simple query of 'select * from table where
lcase(field)='david' results in the error
"Undefined function 'lcase' in expression.". Why is this? What DLL
do I need to recapture and register? Please help me with this quandry
as this machine is useless to me at the moment. BTW - I already
uninstalled and reinstalled office hoping it would restore the missing
file(s).
 
Top