Greetings,
I am developing an application that writes values from an Access 2000
database to an SQL 7.0 server using DAO and linked tables. It seems to
work fine for the first 26 of 108 tables, but part way through the
population of the 27th table it stops and displays a 'Runtime Error
3001 Invalid Arguement' message. Not sure what to make of this.
Any help would be appreciated.
Daryl
For nZone = 1 To p_intZoneCount
If p_bRunZones(nZone) Then
Debug.Print "Writing zone " & nZone & "..."
With p_zneData(nZone)
nMaxRow = .MaxRow - .MinRow
nMaxCol = .MaxCol - .MinCol
For nRow = .MinRow To .MaxRow
For nCol = .MinCol To .MaxCol
rstData.AddNew
rstData!ddRow = nRow
rstData!ddcol = nCol
For nStep = 0 To SCN_STEPS
rstData("ddDensity" & nStep) =
p_intMapData(nStep, nRow, nCol)
Next nStep
rstData.Update <<BONKS HERE>>
Next nCol
Next nRow
End With
End If
Next nZone