Hello,
I will try to do my best explaining this error, please be patient with me.
I have a VBA code that loads values from an Access table into a temporary T-SQL table. The purpose is to do the required math using the server's processor. The logic works perfect if I debug.print the SQL commands from VBA and paste them into a SQL server front end application.
However, if I run the code in access I get a Invalid Object Name pointing to my '#tmpTable' ( this is T-SQL temporary table where I stored the values). There seems to be something about the hashtag or something from that name that Access does not like it. However, it is a requirement in T-SQL in order for me to create the temporary table in that environment. The exact error says Run-time error '3146' ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name '#tmpTable'. (#208)
The code is long and I will have to remove a lot of sensitive information in order to post it here. That is why I have not posted the code. Has any of you experienced something similar? Is the hashtag the issue here?
Thanks for your help!
I will try to do my best explaining this error, please be patient with me.
I have a VBA code that loads values from an Access table into a temporary T-SQL table. The purpose is to do the required math using the server's processor. The logic works perfect if I debug.print the SQL commands from VBA and paste them into a SQL server front end application.
However, if I run the code in access I get a Invalid Object Name pointing to my '#tmpTable' ( this is T-SQL temporary table where I stored the values). There seems to be something about the hashtag or something from that name that Access does not like it. However, it is a requirement in T-SQL in order for me to create the temporary table in that environment. The exact error says Run-time error '3146' ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name '#tmpTable'. (#208)
The code is long and I will have to remove a lot of sensitive information in order to post it here. That is why I have not posted the code. Has any of you experienced something similar? Is the hashtag the issue here?
Thanks for your help!