SELECT * INTO Doesn't work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using SELECT * INTO <temp_table> FROM <sybase-link-table> query. It hangs indefinitely in MSACCESS. When i am using msjet40.dll Version 4.0.6218.0 it works. But when i am using msjet40.dll Version 4.0.8015.0 it hangs indefinitely
I can't use version 4.0.6218.0 as it gives some different error in different scenario. This is happening only in sybase link table
 
I am using SELECT * INTO <temp_table> FROM <sybase-link-table> query. It hangs indefinitely in MSACCESS. When i am using msjet40.dll Version 4.0.6218.0 it works. But when i am using msjet40.dll Version 4.0.8015.0 it hangs indefinitely.
I can't use version 4.0.6218.0 as it gives some different error in different scenario. This is happening only in sybase link table.
Click to expand...

I've heard of some problems with the SELECT * syntax. If you know the
fieldnames ahead of time, try naming them explicitly in place of the
*.
 
No using field names doesn't help either. It gives the same error i.e. it hangs indefinitely.
 
Back
Top