System resource exceeded with linked ODBC MS SQL 2000 table

Hi,

I have a simple query that reads from a linked Access table a bunch of
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11004-system-resource-exceeded-linked-odbc-ms.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11004
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


*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

jrajotte@gmail.com wrote:
> Hi,
>
> I have a simple query that reads from a linked Access table a bunch of
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11004
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11004
have to break it up into several smaller chunks.

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