Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

System resource exceeded with linked ODBC MS SQL 2000 table

Discussion in 'Information Technology' started by jrajotte@gmail.com, Jul 28, 2006.

  1. jrajotte@gmail.com

    jrajotte@gmail.com
    Expand Collapse
    Guest

    Hi,

    I have a simple query that reads from a linked Access table a bunch of
    records (300 000) and append to a linked ODBC MS SQL 2000 table. With
    this configuration, I receive the error "System resource exceeded". If
    I replace the linked ODBC table by a linked Access table, it works
    without error and I can append many hundred thousands of records at a
    time.

    Can someone explain me what is happening,
    Tx
     
  2. Loading...

    Similar Threads Forum Date
    Hard Talk The Caste System: Here's Why It's So Repugnant To Sikhi Hard Talk Aug 15, 2016
    Shabad Numbering System New to Sikhism Dec 1, 2015
    Canada India banned the caste system 60 years ago, but it lives on for many in Metro Vancouver Breaking News Oct 11, 2013
    Devanagari as a Writing System for Punjabi: Plus or Minus for Punjabi? Punjab, Punjabi, Punjabiyat Jul 30, 2013
    India India sets up elaborate system to tap phone calls, e-mail Breaking News Jun 20, 2013

  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    jrajotte@gmail.com wrote:
    > Hi,
    >
    > I have a simple query that reads from a linked Access table a bunch of
    > records (300 000) and append to a linked ODBC MS SQL 2000 table. With
    > this configuration, I receive the error "System resource exceeded".
    > If I replace the linked ODBC table by a linked Access table, it works
    > without error and I can append many hundred thousands of records at a
    > time.
    >
    > Can someone explain me what is happening,
    > Tx


    That append is being logged on the SQL Server and the transaction log might be
    running out of room. Generally DTS FROM SQL Server is better for bulk moves
    like this because they are not logged. Doing it with append queries you might
    have to break it up into several smaller chunks.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     

Share This Page