Set oCacheConn = CreateObject("ADODB.Connection") With oCacheConn .ConnectionString = "Provider=VFPOLEDB.1;Data Source=mydbc.dbc" .CursorLocation = 2 ' adUseServer .Mode = 16 ' adModeShareDenyNone .Open End With oCacheConn.Exec("Create Table mytable ( tRowCreated t(8) Null)") For iNo = 1 to 70000 oCacheConn.Exec("Insert Into mytable (tRowCreated) Values (DateTime())") NextWhere can I put something in there to flush to disk? What is getting bad is the fact that even if something breaks at row 69000 I still have nothing in the .dbf.