Hi
I am currently transfering our data to msde 2000 from access, our largest file is 1.5 million records. I am using a vb program to update these records from text file to the msde database using ADO, this keeps failing to open the database after half the records are loaded, and the whole msde server seems slow??
heres code from my vb program:
hope someone can help.
rstPAFmain.Open "MAIN", , adOpenStatic, adLockOptimistic, adCmdTable
Open "s:\outfiles\Raw PAFPR.txt" For Input As #100
intLoaded = 0
Do Until EOF(100)
    Line Input #100, OpRec
    myarray() = Split(OpRec, Chr(9))
    rstPAFmain.AddNew
    For NN = 0 To 5
        rstPAFmain.Fields(NN) = myarray(NN)
    Next
      intLoaded = intLoaded + 1
        If intLoaded Mod 5000 = 0 Then
          lblPAFCount.Caption = CStr(intLoaded)
        End If
If intLoaded Mod 10000 = 0 Then
rstPAFmain.Update
End If
Loop
      lblPAFCount.Caption = intLoaded
rstPAFmain.Update
rstPAFmain.Close

Is that the only way you can do it? Access (2000,2002,2003) can upsize an Access database to MSDE...If you are friends with someone who has SQL Server, you can install the enterprise manager and query analyzer to graphically view the information (provided network access is enabled on MSDE)...You could optionally create an ADP in Access which will create the tables on the MSDE server, or use Enterprise Manager to import the database...

-T