I am facing problem in sybase link table in MSACCESS.
If i am using "SELECT * INTO <temp access table> FROM <a sybase link table>" it's not working. It is NOT giving any error messages but, it's just hanging with no result.
Any help will of great help.
You're probably using a wuery in passthrough mode.
Did you try to execute the same sql statement directely on your ASE ? In other words, did you check the "select into/bulkcopy/pllsort" option of your ASE database ?
Starting your Access query, what the status of the connection on ASE (via sp_who) ?
No i am not using passthrough query. I have linked the sybase table in access and am using the link table. Thing is that this query is running all most of the machine, just in one machine it's failing. I have checked ASE driver version and it's same for all the machine.