Hi I am trying to setup a pass through query to sql to create a temporary table, insert records and pull back the results after they have been passed through a UDF.
create table #UAI
(User_Abstract_ID varchar(30))
Insert #UAI values ('XURBB_424384')
Insert #UAI values ('XURBB_424385')
Insert #UAI values ('XURBB_424386')
SELECT dbo.GET_CITATION (user_abstract_id) from #UAI
drop table #UAI
This works fine in SQL server query window but Access doesnt think the table exists/wont run this/wont pull back results.
Any ideas on this, many thanks in advance for your help
Oliver
create table #UAI
(User_Abstract_ID varchar(30))
Insert #UAI values ('XURBB_424384')
Insert #UAI values ('XURBB_424385')
Insert #UAI values ('XURBB_424386')
SELECT dbo.GET_CITATION (user_abstract_id) from #UAI
drop table #UAI
This works fine in SQL server query window but Access doesnt think the table exists/wont run this/wont pull back results.
Any ideas on this, many thanks in advance for your help
Oliver
