Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Unanswered: Problem in ACCESS link Tables

    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.

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Re: Problem in ACCESS link Tables

    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) ?

  3. #3
    Join Date
    Nov 2003
    Posts
    3
    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.

  4. #4
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    What's happening only executing the SELECT (without INTO statement) ?

  5. #5
    Join Date
    Nov 2003
    Posts
    3
    It's working fine when i am using just the SELECT statement (without INTO).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •