Overflow
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Date: Wed, 17 Mar 2004 03:15:57 -0800
I have an ADO (VBA) query that runs against SQL Server
with no problem, in this case extracting 96,000 records
that IO am able to loop thru with no problem. However
when I write these records to an Access2002 table (using
Addnew and Update) I get an OVERFLOW error (err.number=6)
when I hit record 32,767. DoEvents doesnt help. Any
ideas anybody ?
Relevant Pages
- Re: Transactions - Infinite Loops
... This still doesn't sound like an infinite loop. ... > It was an unusual SQL Server response that we were unable to duplicate. ... > transaction if the wrong number of felds are being updated (i.e., ... > the query ran okay. ...
(microsoft.public.sqlserver.programming) - Re: Transactions - Infinite Loops
... It was an unusual SQL Server response that we were unable to duplicate. ... the end of the transaction, but the query seemed to work fine - records were ... the query ran okay. ... Now I am thinking that perhaps the transaciton log loop was cuased by some ...
(microsoft.public.sqlserver.programming) - Overflow error
... I have an ADO query that runs against SQL Server ... with no problem, in this case extracting 96,000 records ... that IO am able to loop thru with no problem. ...
(microsoft.public.access.queries) - Re: Retriving data from DB
... I'm using MS SQL Server, I'll try to create view, I just use ASP to ... dinamicaly create SQL query using 2 nested FOR loops. ... > You could probably create a subroutine in an Access module to loop through ...
(microsoft.public.inetserver.asp.db) - Re: CONTAINS performance
... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
(microsoft.public.sqlserver.fulltext) |
|
