how to know if function is Access based or SQL based?
Posted on 2013-09-03
i've asked this question before in some shape and form before, but now with a clearer understand i want to approach it again if yall don't mind (don't be mad at me!!) = ))
i'm writing some SQL queries and need to use functions
1) vba has an object browser. what's the equivalent for SQL?
2) if i know the answer for 1), i don't need to ask this. but i don't think there is an object / function browser for SQL.
so how do if the function i'm called is a SQL or VBA function? let's say i use function xyz and function xyz only exists in VBA but i THOUGHT it exists in SQL too - but it doesn't. how can i find out that VBA is the one running this function? is it through looking at the execution path - will execution path tell me this?
3) if i use any function that has the same name in SQL and VBA, the SQL one will always be called first right?