Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Feb 2001
    Location
    Ohio, USA
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ODBC Link problems (Office 97 / SQL 6.5)

    I have an Access database that runs a macro to create link tables into an SQL database. After having some trouble with the SQL syslog a few weeks ago the tables no longer refresh when created by the macro. When I create a link table manually all is well, when left to the macro the data is two weeks old (corresponding to the date of the SQL trouble). Any idea what might be causing this and how I can recover? <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>
    Pat Russell
    Process Automation Engineer

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Flims, Switzerland
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ODBC Link problems (Office 97 / SQL 6.5)

    Can you post the offending code here?

  3. #3
    Lounger
    Join Date
    Feb 2001
    Location
    Ohio, USA
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ODBC Link problems (Office 97 / SQL 6.5)

    I think I have found the problem. It seems that my ODBC connection was pointing to the wrong database ("master" vice my data "DevDB"). I have corrected this and am transferring the data now. Here is the code anyway... just in case <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>
    Pat Russell
    Process Automation Engineer

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Flims, Switzerland
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ODBC Link problems (Office 97 / SQL 6.5)

    Your code looks fine. I believe pointing at the database was your only fundamental problem.

  5. #5
    Lounger
    Join Date
    Feb 2001
    Location
    Ohio, USA
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ODBC Link problems (Office 97 / SQL 6.5)

    Thanks for the time... <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    Pat Russell
    Process Automation Engineer

Posting Permissions

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