rstACC.CursorType = adOpenKeyset
rstACC.LockType = adLockOptimistic
rstACC.Open "TMP_Fields", cnACC, , , adCmdTable
rstACC!ln = inLN
rstACC!Field1 = inField1
I'm using the above code to add new records to a table in MSAccess db.
As it adds more records (5000+), it appears to slow down.
Am I supposed to be doing something so it doesn't slow down
or am I just imagining it.