mak345
asked on
Run Access query with functions - Excel
I have a query in Access 2010 that calls a function within the database. The query runs successfully when run inside Access. My question is when I try to call this query through VBA in Excel, it does not recognize the function and errors out. Is this possible to perform in Excel?
Is the function something that you, or someone else, has created rather than a standard Access function?
ASKER
It is a function I created.
What does the function do?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, wasn't sure if it was even possible. Doesn't seem like it is.
the solution is to either use DAO connection (JET library) when connecting from excel, or to change the function name.